Thread: vlookup issue
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default vlookup issue

Updated file sent back.

Values in second sheet were stored as TEXT whereas in the first sheet they
were stored as NUMBERS.

You can verify this with ISNUMBER and ISTEXT functions.

To convert TEXT to NUMBERS, enter 1 anywhere, Copy it and then select the
column with text and choose PASTE SPECIAL|Multiply


"MrRJ" wrote:

Just re-sent it.

"Sheeloo" wrote:

I did not get it...

Send it to


after removing "remove."

"MrRJ" wrote:

Just sent you an email.

"Sheeloo" wrote: