Hi Jan, Roger

thank You both for promt replyies.

Jan's solution should work for me, because I need VLOOKUP to look in
sheetB if it does not find data in sheetA, but... I can't make it to
work this is what I made of it:
=IF(ISERROR(VLOOKUP(B10,ArtA!A2:C55000
ArtB!A2:C49424,3,FALSE)),VLOOKUP(B10,ArtA!A2:C5500 0,3,FALSE),VLOOKUP(B10,ArtB!A2:C49424,3,FALSE))


This only returns data from "ArtA" and returns '#n/a' when quired data
is in "ArtB".


It is probably obvious that I have started to use Excel today.:)


--
Mare
------------------------------------------------------------------------
Mare's Profile: http://www.excelforum.com/member.php...o&userid=27644
View this thread: http://www.excelforum.com/showthread...hreadid=492126