Vlookup help

[Brett Lloyd]

I have two collums of data I would like to compare and then return th
information from a third into a new collum.

here's what I have.

Pair BLD This is sheet 1

1 200
20 401

500 200


Sheet 2 has

PAIR BLD
20

The building number is the collum I want to populate. I have over 200
entries on the first sheet. I want to compare the PAIRS to each othe
and where I see a match I would like the BLD info populated on shee
two.

Is this possible? If so can I get some examples? I could have sworn
had done something like this before but the problem eludes me.

Thanks,

Brett Lloy

 

[Aladin Akyurek]

See an example multi-key lookup in:

http://tinyurl.com/6bqto

 

[Brett Lloyd]

Got it figured thanks.

=VLOOKUP(FR4,'Cable Book'!A4:B3614,2,FALSE)

FR4 = the cell to compare on sheet 2

Cable Book = Sheet one
A4:B3614 = range to look in

2 = returning the info in collum B


FALSE = must be an exact match.

Thanks for the help folks.

Bret