QUICK HELP - Retrieve value based on two column criteria

J

jay

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.
 
B

Bryan Hessey

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
 
Top