Murray Brown

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)

It doesn't, however, work on a different sheet

=VLOOKUP(A5,staff,6,0)

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Is the A5 on the same sheet?

ASKER

Here is the file. I am trying to do a VLOOKUP on the sheet "Template" that references the Sheet Data1

Scheduler.xls

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

=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

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

ASKER

Thanks for the help