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" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>

[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" <[email protected]> wrote in message
news:[email protected]...
> =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" <[email protected]> wrote in message
> news:[email protected]...
>> 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]

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> >
=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" <[email protected]> wrote in message
> > news:[email protected]...
> >> 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
> >>
> >>
> >
> >
>
>

[Paul]

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


"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> >
> =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" <[email protected]> wrote in message
>> > news:[email protected]...
>> >> 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
>> >>
>> >>
>> >
>> >
>>
>>
>
>