# Solved Text & Number As An Argument

May 20, 2012 at 08:45:22
Specs: Windows 7
 HiThis is my first post on here so I would first like to thank the people on here that give up their time to help others...brilliant!I'm trying to create a spreadsheet that looks at a cell that contains both text and numbers. Examples of cell entries are: B20, B25, and so on. Both the letter and the number can change which means that nested IF will be unsuitable due to there being more than 7 permutations. I usually use & in my formulas as this enables me to have unlimited permutations: =IF(\$F16="UC",VLOOKUP(\$G16,UC!\$D\$8:\$X\$38,2, FALSE),"")&IF(\$F16="UB",VLOOKUP(\$G16,UB!\$D\$8:\$X\$88,2, FALSE),""My question is, how can I lookup a cell value that contains both text and a numeric value?

See More: Text & Number As An Argument

#1
May 20, 2012 at 11:16:50
 A =Vlookup() will function just fine using Text Strings or Numbers.If your data looks like:``` A B 1) B20 Alpha 2) B25 Beta 3) F500 Delta ```In cell C1 enter the Text String B25In cell D1 enter the formula: =VLOOKUP(C1,A1:B3,2,FALSE)and you should get Beta as your answer.MIKE