| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort a range of numbers ignoring preceding letters | Excel Discussion (Misc queries) | |||
| Convert letters into numbers. i.e. ABCD = 52 | Excel Worksheet Functions | |||
| Range names are displaying in big blue letters on sheet | Excel Discussion (Misc queries) | |||
| VLOOKUP Limitations | Excel Worksheet Functions | |||
| how to sum up letters instead of numbers? | Excel Discussion (Misc queries) | |||
Threaded Mode
