I'm confuesed,

I see you done something but when I edit the cells to text or anything
else nothing seems to work. Make them both text, both general, both
numbers etc. Now I coppied your formula for the lost row. In my sheet it
shows the formula without doing anything =VLOOKUP( etc

What is happening in this sheet, corrupted?

W


--
willemeulen

Blink1 *Willem van der Meulen* BSc Soil & Water Eng (Netherlands)
------------------------------------------------------------------------
willemeulen's Profile: http://www.thecodecage.com/forumz/member.php?userid=285
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=104270