I have a list of "old" numbers and I need to find this number in a list on another tab and return the value of the new number from the adjacent cell.
I have attached a sample file to help.
Your assistance is appreciated
I have a list of "old" numbers and I need to find this number in a list on another tab and return the value of the new number from the adjacent cell.
I have attached a sample file to help.
Your assistance is appreciated
Try this...
Entered in B4 and copied down:
=VLOOKUP(A4,'data source'!A:B,2,0)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
I'm sorry, but this does not return the new value adjacent to the data source. Thank you though.
Hmmm...
It works for me.
Here's your file with this implemented.
Maybe this could work for you.
Formula:Please Login or Register to view this content.
If you know the range of the data source, replace the full column references with the range of your data.
Note:
I tried Tony Valko's formula and it works perfectly....check how you entered it.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Tony, You have saved my life today. I have such a monumental task that is now reduced to a few minutes.
Hurray!!!!!
Good deal. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks