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/