Does anyone know why vlookup in excel would fail to recognize an alpha-numeric cell when the match definitely exists? This occurs when I have created a spreadsheet from data transferred from SAP. The data cells are both strictly numeric and alpha-numeric. Vlookup works fine (finding an exact match on numeric fields) but returns #N/A on the alpha-numeric. I cannot use "TRUE" in the range lookup as I need exact matches and I know the exact match is in the array I'm looking in. I've tried clearing all formats, formatting them as text, etc. but it doesn't work. IT DOES WORK when I create a test grid exclusively in excel........ any ideas??