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

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.

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&S heet2!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

"Doug" wrote in message
...
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.

Thank you for your help!

"Doug" wrote:

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.

you're welcome

"Doug" wrote in message
...
Thank you for your help!

"Doug" wrote:

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.