See the attached file "Lookup.xlsx". I would appreciate a formula that returns the part name from sheet 1 that corresponds to the part no on sheet 2.
Thanks.
See the attached file "Lookup.xlsx". I would appreciate a formula that returns the part name from sheet 1 that corresponds to the part no on sheet 2.
Thanks.
In C3 and copy down. =VLOOKUP(B3,Sheet1!$B$3:$C$7,2,FALSE)
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
I had to insert the following before the Sheet1 reference: [Lookup.xlsx]. Why is that?
Maybe this
Enter formula in C3 and copy down
Formula:Please Login or Register to view this content.
v B C 1 2 Part No 3 A Hammer 4 XY Wrench 5 BC Screwdriver 6 UV Hoe 7 KI Spade 8 LO 9 MN
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Is Sheet1 in a different workbook than Sheet2?
Why is this different?
What are you referring to?Why is this different?
They will give you the same results, but there is almost always more than one way to skin a cat. Vive la différence!
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks