Is there a way to look at 2 ranges, on two different sheets.. Basically i have 1 list of data on one page and another list of data on the other page and i want the vlookup to look at the cell and check both lists of data.
Is this possible?
Is there a way to look at 2 ranges, on two different sheets.. Basically i have 1 list of data on one page and another list of data on the other page and i want the vlookup to look at the cell and check both lists of data.
Is this possible?
can you not run iferror vlookup on this range gives error look up next?
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Are you expecting there to be just one match over the two lists, or more than one? If the latter, then VLOOKUP won't be sufficient. More detail would help.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
just one match.
Try something like this...
=IFERROR(VLOOKUP(A2,Sheet1!A:B,2,0),IFERROR(VLOOKUP(A2,Sheet2!A:B,2,0),""))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks