Error in VLookup

[Fantastic]

Hi everyone,

I am getting frustrated with my VLOOKUP formula. There is an error, but I can't find it and fix the problem. Can anyone help? I've attached a example of what I have to work with.

I have highlighted the column from which the value must be selected.

=VLOOKUP(A2;E$2:G$6543;7;0) : I get a #Ref error.

Thanks for your help.

Example.xlsx

[AlKey]

You range says E$2:G$654 and 7 is the column. You column count start from the first range "E". So, you formula is not working because the it looks for the seventh column and it's not there.

[Fantastic]

Ahhh, thanks. Better one who knows than a thousound without a clue.

Thanks so much. It's been a while since I worked with Excel and it can be frustrating at times.

Much appreciated.

Good night.

[AlKey]

You're Welcome. Don't forget to thank those who helped by clicking on Add Reputation *

[Tony Valko]

Change the col_index_num to 3:

=VLOOKUP(A2;E$2:G$6543;3;0)