Hey Everyone!
I'm needing to lookup a cell's numerical value only on another sheet and return an adjacent value.
Ex: 123456789R is the cell I need to look up in a different worksheet. The other worksheet will have 123456789 in one Cell and a CB0001234 2 columns over. I am needing to look up the numbers in the other worksheet and return the CB number to the cell next to the 123456789R number. I've attached an example worksheet for reference also.Example.xlsx
Formula:
Please Login or Register to view this content.
but only with string of format 123456789N i.e single non-numeric as last character following the number
Last edited by JohnTopley; 02-07-2023 at 03:21 PM.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Or maybe, with 365:Formula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thank you!!
You're welcome. Thanks for the rep.
This should cope with more complex values, and duplicate entries.
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks