This 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?