Hi,
I have a simple worksheet with two columns (see below). Column A contains text that finishes with a unique number. Is it possible to use a formula to search the text in column A for the occurrence of a specific number (say "21") and for the formula to return the contents of the adjacent cell in Column B (row 3, "you found me")?
Row Column A Column B 1 some text 5 bla bla 2 more text 15 nothing to say 3 even more text 21 you found me
Thank you for your help.
Steve
Hello Steve
If your example data was in cells A2:B4 and your lookup number, say in cell D2, then try the following formula:
Just to add an alternative you could also use VLOOKUP:
Please Login or Register to view this content.
Hope this helps.Please Login or Register to view this content.
DBY
Last edited by DBY; 08-19-2012 at 07:20 AM. Reason: Added alternative solution
Excellent, thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks