Hi Sally,
If you can insert a new A column in Sheet2 and use =B1&C1 (giving ONE611 in
A1); copy down column.
On Sheet1 use =VLOOKUP(A1&B1,Sheet2!$A$1:$D$3,4,FALSE)
Of course, the ranges need not end at 3 but could be A1:D200, or whatever

If you cannot insert a new A column then in a column to the right of the
data on Sheet2 add =A1&B1 (let's say this is in column D
On Sheet 1 use
=IF(ISNA(MATCH(A1&B1,Sheet2!$D$1:$D$3,0)),NA(),IND EX(Sheet2!$C$1:$C$3,MATCH(A1&B1,Sheet2!$D$1:$D$3,0 )))
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Sally" wrote in message
...
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