Hi

Having a few issues with VLOOKUP, basically if Part Numbers (ColumnD)
contains text and numbers it is okay, hoever, rows that just contain
numbers only or numbers and slashes or dots are showing as #N/A in
ColumnE, have searched on here (http://www.contextures.com/
xlFunctions02.html) and tried looking at following but does not seem
to work. any help appreciated!!!

Here is formula currently:

=VLOOKUP(D2,CommodityCode,4)

'CommodityCode' is named Range on another sheet in same workbook

Here are results for column D and E respectively:

Part Number    Commodity
GW                   Small Power
GU7271BSS    Small Power
1000/8                   #N/A
E3PP158                   Mains Distribution
GW                   Small Power
2035.802                   #N/A
8002.01                   #N/A
GU7271BSS    Small Power
010-100-100-08    #N/A
7027                   #N/A
LMA10                   Lighting

Any help appecated!!!

Potsy