1) I need to get the entire line by using the Acc Code.
If acc code is identified, then the date, amount, and cleared should be shown...
2) i need lookup the same after satisfying one condition like.. if d2=yes, then copy the entire line orelse NA,false wtevr, Please help
Well, you're right if you want to search for an approximated value (in case the exact value is not found) in your job. In this case the parameter Range_Lookup must be completed with 1 or True or not filled.
But if you want to search for the exact value in your data, the left column can be in any order.
In this case simply fill out the Range_Lookup with 0 (zero) or False.