It would help if you could advise the syntax of the formula you are trying to
use and what you mean by 'it doesn't work', i.e. is it returning #N/A or is
it returning the wrong result?

In the meantime, have you checked that the cell you are looking up and the
range you are searching are both text format, or are both numeric - if this
isn't the case you will likely get #N/A a result.

Also, the first column of the range you are searching must contain the data
you are searching for......

"Frank" wrote:


Why is it that often this formula doesn't work?
Do I need to clean up cells, or do they need to be in the same format?



--
Frank


------------------------------------------------------------------------
Frank's Profile: http://www.excelforum.com/member.php...nfo&userid=464
View this thread: http://www.excelforum.com/showthread...hreadid=497848