Hi guys,

I'm hoping someone can help me out ! I have 2 worksheets and what i need to
do is compare 2 cols from one to 2 cols in another - if they match then bring
across a value from an X col.
It's basically what a Vlookup does but instead of comparing one col and
brining acorss a value i want to make sure that two cols match before it
brings across a value.

So in lay terms :

If Value in cell Sheet1!A1 = a value in Sheet2!$A$500
AND Then
value in Sheet1!$B$1 = The value in cell D from the same row in which you
found the first matching value
THEN
bring across the value in cell F from that same row

Thanks guys and gals!!
Deb