Looked at some of you responses regarding excel and you seem very
knowledgeable. Have a question involving a lookup.

Scenario

Two Sheets



Sheet one

Has an invoice number on it.



Sheet two

Has a check number that may or may not have paid multiple invoices.

It is listed this way.



Column 1 column 2 column 3
et all

Check number invoice number invoice number




What I would like to do is use a lookup on sheet one that checks sheet two
for the invoice number (separate invoice numbers are located in columns B
through whatever) and returns what check it was paid on (checks located in
the left most column).







Cant figure out an easy way to do it and was wondering if you had any ideas.





Regards,
jb