I have an array with columns I and J. I contains two digit numbers and J contains text.
Column E in worksheet contains five digit numbers. I want to pick the text i J column depending the first two digits in column E so this is what I did:
VLOOKUP(LEFT(E9,2),$1$I:$J$25,2,FALSE) and I get #N/A error but if I put in a number instead of the substring
VLOOKUP(11,$1$I:$J$25,2,FALSE) it works.
The E and I columns are formatted as NUMBERS. I have tried GEBERAL and there is no change.
Any suggestions?
Bookmarks