Hi

Jan Karel has posted you a solution to look in ArtB if the data is not found
in ArtA.
I interpreted your request slightly differently and maybe incorrectly) as
you wanting to add both values to the cell where the formula is placed.
If so then
=IF(B10="","",VLOOKUP(B10,ArtA!A2:C55000,3,FALSE)+
VLOOKUP(B10,ArtA!A2:C55000,3,FALSE))

Regards

Roger Govier


Mare wrote:
Hi, help me with this please

=IF(B10="","",(VLOOKUP(B10,((ArtA!A2:C55000)(ArtB! A2:C49424)),3,FALSE)))

this should return value from 3rd column. It works with only one
sheet(ArtA), but when i try to include 2nd sheet (ArtB) it returns
'#REF!' error.
Question should probably be:" How to include 2nd sheet in VLOOKUP
function? "

Thanks