A more proper way would be

=IF(ISNA(VLOOK($A7, returnall, 32,0)),"",VLOOK($A7, returnall, 32,0)*100)

and you can change 32 to whatever fits within the named range "returnall"
You cannot change it so it tries to pull for a column that is beyond the
last column in "returnall"



--
Regards,

Peo Sjoblom



"hoachen" wrote in message
...
Previous staff have form the function below and I don't understand what it
means. He was no more longer work here. I need someone to explain what it
say.

Here is the function look like
=IF(ISERR(VLOOK($A7, returnall, 32,0)*100) ," ",VLOOKUP($A7, returnall,
32,0)*100)

Can anyone also explain why the 32 can be change to any number, what it
represent?

Thanks for anyone trying to help
Cheer,
hoachen