Hi,
I want to vlookup in sheet 1 col A & col B - where both these values appear
in the same row in sheet 2, give me the data in the 3rd column.

SHEET1
A B C D
1 ONE 666 123 SECURITY
2 FIVE 818 682 NUMBER

SHEET2
A B C
1 ONE 666 4,876.12
2 ONE 818 6,821.11
3 FIVE 818 1,211.01

AFTER VLOOKUP PERFORMED - RESULT SHOULD LOOK LIKE THIS;
SHEET1
A B C D E
1 ONE 666 123 SECURITY 4,876.12
2 FIVE 818 682 NUMBER 1,211.01
3 SIX 818 682 SECURITY N/A

Thanks
Sally