Vlookup

[Paul]

In my spreadsheet i have a worksheet(1) with three columns.
A B C
data1 data1 data1
data2 data2 data2

I would like to use the VLOOKUP function to bring data from column c into
another worksheet(2), when data entered into worksheet(2),columns A and B,
matches data with worksheet(1)
Is this possible?
Please advise

Paul

 

[Bob Phillips]

=INDEX(Sheet1!C1:C1000,MATCH(1,(Sheet2!A2=Sheet1!A1:A1000)*(Sheet2!B2=Sheet1
!B1:B1000),0))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Paul]

Thanks, but still not working. Perhaps I can elaborate:-
In sheet1, column A, there may be duplicate values throughout the column as
there will be in column B also.

A B C
1068ass 10 1.45
1068ass 20 2.45
1068ass 30 4.56
1068bss 10 3.56
There are duplicate values in column A and B but there will only ever be one
row where (A) value and (B) value will match my data in sheet 2.
What i am hoping to achieve is:
In sheet 2, I enter "1068ass" in cell A1 and "10" in cell B1. the figure
"1.45" will then auto fill in cell C1

Many thanks

Paul

 

[Bob Phillips]

Which is exactly what I gave you! I understood the question perfectly.

All you had to do was change my references to A2 and B2 on Sheet2 to A1 and
B1, and that was it.

Don't forget Ctrl-Shift-Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Paul]

Did forget the Ctrl-Shift-Enter!!!! - Working fine now. Many thanks