Hi,

I'm running a vlookup of a number that appears as the result of a
macro.

However the vlookup is not working (#N/a appears). If i retype the
number - instead of using the result output by the macro it still
doesn't work.

However if i copy the number from the table being used inthe vlookup it
works just fine and produces the expected results. Anyone got any
ideas why this is happening and more importantly, any ideas how i can
fix this please?


---
Message posted from http://www.ExcelForum.com/

suspect the table contains the string 123 rather than the number 123

something to try:
=vlookup(Text(123,"#"),Table,2,False)



to handle both

asume your value is in A1

=if(iserror(vlookup(A1,Table,2,false)),vlookup(Tex t(A1,"#"),Table,2,False),V
lookup(a1,Table,2,False))

Or clean up the data in your table.

--
Regards,
Tom Ogilvy


ali wrote in message
...
Hi,

I'm running a vlookup of a number that appears as the result of a
macro.

However the vlookup is not working (#N/a appears). If i retype the
number - instead of using the result output by the macro it still
doesn't work.

However if i copy the number from the table being used inthe vlookup it
works just fine and produces the expected results. Anyone got any
ideas why this is happening and more importantly, any ideas how i can
fix this please?


---
Message posted from http://www.ExcelForum.com/

try using trim around any entries, I have found this to help when ther
are hidden spaces in words. Also make sure the last input into th
vlookup is true or false depending on if your table is in alphabetica
order.

Keith
www.kjtfs.co

--
Message posted from http://www.ExcelForum.com