the lookup I am using is:
=VLOOKUP(A21,Physical!$C$5:$AN$114,27,FALSE)

I am using the lookup in a large series of consecutive rows and columns
and within the table array there are empty cells. I need the lookup to
return the value of all cells but when it arrives at a blank cell I
need it to return a blank cell. Currently when it arrives at a blank
cell it returns the date 00-Jan-00.

can anyone help?

Thanks in advance!!


--
Pedros
------------------------------------------------------------------------
Pedros's Profile: http://www.excelforum.com/member.php...o&userid=28202
View this thread: http://www.excelforum.com/showthread...hreadid=517645