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
what would you do with the IF command?
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