Working with two ranges

Hi,

I have this problem : I have two ranges, each one is a range of values. I'm looking for a command that checks if there's a same value in those two diffrenet ranges, and in case there is, then make some conditional sentence like "if - then". I mean if the value "1492" is in each of these ranges then sum it or copy it, etc.

Thanks in advance,
Udi

Hi,

The following formula will look for the value of the cell G1 in range A1 : B6 and then will add the value in column B to the value in H1.

=IF(ISERROR(VLOOKUP(G1,$A$1:$B$6,2,0))," ",SUM(VLOOKUP(G1,$A$1:$B$6,2,0),H1))