Hi,
I'm trying to write an IF formula that will return a number if the word in the adjacent cell begins with a specific letter.
Here's what I want to show:
City 01 Express 02 Overnight 03
So "C" would return 01, "E" would return 02 and "O" would return 03.
Not quite sure where to start. Any help would be much appreciated.
Last edited by BPSJACK; 04-03-2014 at 07:58 AM.
Several ways of doing this. In the attached example I've used a combination of LEFT and VLOOKUP with a small lookup table (the yellow cells) to look at the first letter of the text in column A and return the relevant number in column B.
You could use LOOKUP for another method, but I find this VLOOKUP method is easy to maintain if that list gets longer.
Maybe use vlookup with a wildcard, so if your data above is in A1:B3 and "C" is in C1 then
=VLOOKUP(C1&"*",A1:B3,2,0)
Please Login or Register to view this content.
Click on the star if you think I helped you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks