Thread: vlookup returns #N/A if value contains letters and range numbers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
checkQ checkQ is offline
external usenet poster
  
Posts: 38
Default vlookup returns #N/A if value contains letters and range numbers
A B C
040W02193A 040W02193A0B 040W02193A
#N/A 1 1028600680B 1102900068


Formula used in column A is=VLOOKUP(LEFT(B1,10)&"*",C:D,1,0)

The value that I am looking for is in the first 10 characters in column B
that match the first 10 characters in column C

The formula works for the first line but returns an #N/A for the second
line
I believe it is because my column B has the letter B in it and column C does
not have any alphabet. Does anyone know a formula to fix this?.




Reply With QuoteReply With Quote