vlookup

[nnadimi19]

Good morning folks;
I have a vlookup question. Is there a way to vlookup using two criteria instead of one. Example: I have a sheet #1 that has claim number and exposure type, and sheet # 2that has claim number exposure type and a description. I want to vlookup the second sheet using the claim number and the exposure type from sheet #1 and when there is a match to add the description from sheet#2 to sheet #1.


Sheet #1

Claim # Exposure
11111 222
22222 333
66666 666
00000 000

Sheet # 2
Claim # Exposure Description
00000 000 aaaaaaaa
00000 111 bbbbbbbb
11111 222 ccccc
22222 333 ddd
66666 666 eeee
66666 555 fffff

final result of sheet# 1
Claim# Exposure Description
11111 222 ccccc
22222 333 ddd
66666 666 eee
00000 000 aaa

Thanks in advance

 

[DonkeyOte]

best way around this is to create a unique identifier in sheet2

so have in a1 sheet1

=b1 & c1 (where b WAS a and c WAS b prior to inserting column a)

highlight A:D and name DATA

then in c1 on sheet2

=vlookup(a1 & b1, DATA,4,false)

 

[Aladin Akyurek]

See my contrib in:

http://mrexcel.com/board/viewtopic.php?topic=22767&forum=2