Major Vlookup issues

[DawginAuburn]

I was wondering if someone could evaluate my data and let me know where my equation had gone wrong.

Equation:

=VLOOKUP(A2,$A$2:$E$14,4,FALSE)

I attached an excel file to make it a little more clear as to what I am getting at, but, instead of searching a vertical column and finding a value, the function is just pulling over a column and giving me identical values. The excel document explains it a little better. Thanks in advance!

Thanks a lot guys, total lifesavers!

[arthurbr]

What I am trying to do: I want the vlookup function to look for A2 Account number search column E and then bring back the matching value from Column d to Column C. I have thousands of more values in D than I do in E, will that matter?

But Column D is empty??

[sweep]

Hi,

Does this:

=INDEX($E$2:$E$26,MATCH(A2,$F$2:$F$26,0))

in C2 and copied down give you the correct result?

[martindwilson]

you cant look up to the left use index/match instead
=INDEX($E$2:$E$14,MATCH(A2,$F$2:$F$14,0))

[arthurbr]

Left lookup :

Please Login or Register  to view this content.

[martindwilson]

well you cant normaly! i forgot that trick

[arthurbr]

We discussed that one before http://www.excelforum.com/excel-gene...unction-2.html