Numbers only match numbers, so it is implicit if your lookup value is a
number.

--
Regards,
Tom Ogilvy


"Darin Kramer" wrote in message
...


Thanks, works perfectly

Do you perhaps know how to say if cell A1 is text, then ignore, if its a
number then multiply by 1.
(I need to run only on numbers not on text that is within the sample..)



*** Sent via Developersdex http://www.developersdex.com ***