Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
COURSE of the MONTH
10 days, 10 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
VLOOKUP with other sheet
Posted on 2012-12-21
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)
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3
3-
2
- +1
9 Comments
Active today
it works for me just fine; what error do you get?
and with "other sheet" you mean really just another sheet in the same workbook?
can you upload the file (or a sample where you reproduce the issue)?
and with "other sheet" you mean really just another sheet in the same workbook?
can you upload the file (or a sample where you reproduce the issue)?
Agree with AngelIII, works OK for me - you shouldn't need to refer to the sheet for a named range, is the lookup value the same, where is A5?
regards, barry
regards, barry
Active 2 days ago
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
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
Featured Post
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents. The steps to find the Templates folder path are …
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications. You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Suggested Courses
Course of the Month10 days, 10 hours left to enroll
764 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.