I need a VLOOK-UP formula that uses two look-up vaiables in seper.

[Guest]

I have 2 columns - client and placement date on sheet 1 and on sheet two I
have 3 columns - client, placement date, and collections. I need a look-up
formula to look up the client and placement date on sheet 1 and insert to
collections from sheet 2 on sheet 2.

 

[JulieD]

Hi Doug

assume your client & placement date data is in cells A1 and B1 respectively
on sheet1
on sheet 2, your data goes from A1:C100

a formula that you can use to return the collection information is
=INDEX(Sheet2!C1:C100,MATCH(A1&B1,Sheet2!A1:A100&Sheet2!B1:B100,0))
note, this is an array formula and needs to be entered using control & shift
& enter

note also, if you sheet2 sheet name has a space in it, you'll need to
enclose the sheet name in single quotes

Cheers
JulieD

 

[Guest]

Thank you for your help!

 

[JulieD]

you're welcome

Thank you for your help!