QUICK HELP - Retrieve value based on two column criteria
 

I have three columns in worksheet A (id,name,city) in worksheet B I have
(id,name,city) where the ID is not populated. I need to populate worksheet
b(id) with worksheet A(id) where the name and city are equal. Just so you
know, worksheetA has a lot more values than B so I can't just copy/paste.

Jay,

for a quick one-off solution, make a column of concatenated A and C,
followed by column B, (say in columns D and E),

(in D1 put =A1&C1
in E1 put =B1
and formula copy for the extent of your data)

then in the blank column B put

=vlookup(A1&C1,sheet2!D1:E9999,2,false)

Hope this helps


jay Wrote:
I have three columns in worksheet A (id,name,city) in worksheet B I
have
(id,name,city) where the ID is not populated. I need to populate
worksheet
b(id) with worksheet A(id) where the name and city are equal. Just so
you
know, worksheetA has a lot more values than B so I can't just
copy/paste.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=469965