View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Diana Diana is offline
external usenet poster
 
Posts: 61
Default make it text in vlookup

I have a vlookup table like so:

234, 112
911, 999
260/1, 888
9W2, 777
..
etc..

The lookup works fine when there is text, ie. if I pass in "9W2", it returns
777 as expected. It does not work where there are only numbers eg. 234, it
doesn't recognise that it should return 112.

I have tried to make it treat it as text but nothing works.