vlookup not working

[Rob K]

Hi,

Having trouble with this formula:

= VLOOKUP(A5, Employees!B3:D90,Employees!D:D,FALSE)

But I don't know what is wrong. Basically, I have a sheet with all employees, by last name, first name, salary. I am trying to make it so that on the other sheets, it pulls this value from this sheet.

Can any one spot what the issue is?

[Kaper]

use column NUMBER in current range:

= VLOOKUP(A5, Employees!B3:D90,3,FALSE)

[Fotis1991]

Hi

VLOOKUP does not works like that. See the link and if you still have problems upload a small sample workbook

http://www.contextures.com/xlFunctions02.html

[Rob K]

Perfect, thank you both, I thought I had looked it up, but just missed that the value of the column is supposed to be the column number within the range, makes much more sense. Thank you.

[Rob K]

One more quick question, is there a way to do 2 cells together, I can't get:

= VLOOKUP(A5:B5, Employees!B$3:D$90,3,FALSE)

to work, I have tried putting A5:B5 in Brackets, and I have tried using &. Is this not possible, it's just surname is in one column and first name in another, I would like it to differentiate between the 5 smiths we have working here.

Kind regards

Rob

[Fotis1991]

An idea is to use 1 helper-hidden column(a2&b2) in eatch sheet concatenating(=a2&b2) the names and use these columns as reference in your formula and another one, is to use an ARRAY INDEX&MATCH formula.

[Rob K]

Thanks Fortis, I used the helper hidden column in the end.

[Fotis1991]

You are welcome and thanks for the feedback.

As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.