VLOOKUP formula help

[dmcronin]

Hi all,

Any help with the following problem of mine would be a great help

I have three rows of numbers:

82630384
82630399
82630550
82630550
82630551 - Row A

82630384
82630399
82630550
82630551
82630585 - Row B

95046769
95046741
95046305
95046788
95046373 - Row C

What I would like to be able to do is - for each entry in row A, find it in row B and then return it's matching value in row C.

e.g. take the number 82630551 which is the fifth entry in row A & the fourth entry in row B. I would like my formula to match this as the fourth entry in row B and return the corresponding fourth value from row C i.e. 95046788

Any ideas would be much appreciated!

[Maistrye]

Actually, you probably want HLOOKUP if your data is presented in rows like you indicated.

Try:

= HLOOKUP(A1,$B$1:$C$5,2,FALSE)

Scott

[VBA Noob]

Hi,

I would try this and drag down

=INDEX($C$1:$C$5,MATCH(A1,$B$1:$B$5,0))


VBA Noob

[dmcronin]

Sorry guys, the data I have is three columns not three rows as indicated in my original post...

I can match up each entry in column A with it's match in column B ok, the problem is getting the function to return the corresponding entry from column C - i.e. if 5th entry in A is found as fourth entry in B then return fourth entry from C

[VBA Noob]

Hi,

My example did use three columns. See attached example

http://www.savefile.com/files/253251

VBA Noob

[dmcronin]

Excellent... thanks VBA Noob

Just one thing do the columns have to be text or nums in order for the statement to work or can it be applied to any kind of column formatting?

And cheers once again!

[VBA Noob]

Hi,

Depends on the formatting.

If you format A to C as Text it still works. If you enter a number as '82630551 and then delete the ' it won;t work.

Best to have all numbers stored as text converted to numbers

VBA Noob