Glad you got it working there !

what would you do with the IF command?
.. =IF(A2="","",VLOOKUP(A2,Sheet2!A:G,7,0))

The IF as used above (=IF(A2="","", ...) is just a simple error trap to
return a neat "blank" look in the formula cell should the lookup cell A2 be
empty/cleared. It should also help a little with calc performance, as
there's no need to calculate further the VLOOKUP if A2 is empty/cleared <g.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"inigo45" wrote in
message ...

Hallo,
I have tried VLOOKUP and HLOOKUP, the datas are in the array in Sheet2
in col. C, so I was successful with
=VLOOKUP(B3;Sheet2!C4:G1000;7).
Thanks to your thoughts, which brought me to the right formula. BTW
Cheers,
Juergen


--
inigo45
------------------------------------------------------------------------
inigo45's Profile:
http://www.excelforum.com/member.php...fo&userid=5926
View this thread: http://www.excelforum.com/showthread...hreadid=504269