Hi I have the attached the document I am having issues with. Column E is the output. I need E to look at Column D and then match it to Column A. I tried vlookup but did not work. Hope you can help.
Hi I have the attached the document I am having issues with. Column E is the output. I need E to look at Column D and then match it to Column A. I tried vlookup but did not work. Hope you can help.
For VLOOKUP to work, you have to have the lookup value on the left of the table, so Code# has to be in column A of your table and Doc# has to be in column B.
Then use this formula
Formula:Please Login or Register to view this content.
Last edited by gmr4evr1; 02-28-2017 at 05:00 PM. Reason: Added formula
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
For what you want to accomplish you need to use INDEX/MATCH
Enter in E2 and copy down
Formula:Please Login or Register to view this content.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks