Link to home
Start Free TrialLog in
Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland

asked on

VLOOKUP with other sheet

Hi. When I use the following VLOOKUP on the same sheet as the range "staff" it works fine.
It doesn't, however, work on a different sheet

=VLOOKUP(A5,staff,6,0)
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Is the A5 on the same sheet?
Avatar of Murray Brown

ASKER

Here is the file. I am trying to do a VLOOKUP on the sheet "Template" that references the Sheet Data1
Scheduler.xls
This formula works for me

=VLOOKUP(A5,staff,4,0)

.....but the names need to match - you have "Anthony" on one sheet (with an "h") and "Antony" (without "h") on the other

regards, barry
Also I think the names need to be in order to get correct results
>Also I think the names need to be in order to get correct results

No, that's not correct - VLOOKUP with a 4th argument of FALSE or zero will give you an exact match only - the lookup range doesn't need to be sorted (that only applies when 4th argument of VLOOKUP is TRUE or 1)

The formula used should work OK on the data given, as long as the lookup value finds a match

regards, barry
Thanks for the help