Lookup for an amount from several rows

**cyee** · 01-06-2011, 09:38 AM

Dear All,

I really appreaciate someone could help me on this problem.
Inorder to have a clear understanding, I have attached the file here.

When you look at LC BALANCE sheet, I would like to Lookup for LC number from EXPORT sheet & would like the fomular to auto fill in the invoice & invoice amt for me whenever same LC number is entered in EXPORT sheet.

The invoice number can be 9901299 or either TK10110002S. The fomular my friend created for me seem not working.

Thank you inadvance for help.

Best Regards.

**NBVC** · 01-06-2011, 09:45 AM

The workbook is password protected.

**cyee** · 01-06-2011, 11:42 PM

Sorry the password is 789789

**cyee** · 01-07-2011, 04:19 AM

Sorry the password is 789789

**DonkeyOte** · 01-07-2011, 04:55 AM

Originally Posted by cyee

The fomular my friend created for me seem not working.

If you look at the formula in B8 you will note there is a #REF! error.
Replace the #REF! text (only) with $P$5 and confirm change with CTRL + SHIFT + ENTER
Once corrected copy B8 down over remaining rows