vlookup and hlookup in the same formula
 

Hi,
I have a spreadsheet that I would like to pull data from a pivot table on a
different sheet. The data I have would need to pull from both the rows and
the columns. It would look like this:
Labor Code x Labor Code y Labor Code z
Name
Name
Name
Name

I would like the lookup to reference the name and the labor code from the
pivot table. Is there a way to combine a Vlookup with an Hlookup? Thanks.

vlookup and hlookup in the same formula
 

=INDEX(data range,MATCH("mama",A1:A100,0),MATCH("Labor Code y",A1:C1,0))

Adjust to suit


"lindsayhyle" wrote:

Hi,
I have a spreadsheet that I would like to pull data from a pivot table on a
different sheet. The data I have would need to pull from both the rows and
the columns. It would look like this:
Labor Code x Labor Code y Labor Code z
Name
Name
Name
Name

I would like the lookup to reference the name and the labor code from the
pivot table. Is there a way to combine a Vlookup with an Hlookup? Thanks.

vlookup and hlookup in the same formula
 

Thank you!

"Teethless mama" wrote:

=INDEX(data range,MATCH("mama",A1:A100,0),MATCH("Labor Code y",A1:C1,0))

Adjust to suit


"lindsayhyle" wrote:

Hi,
I have a spreadsheet that I would like to pull data from a pivot table on a
different sheet. The data I have would need to pull from both the rows and
the columns. It would look like this:
Labor Code x Labor Code y Labor Code z
Name
Name
Name
Name

I would like the lookup to reference the name and the labor code from the
pivot table. Is there a way to combine a Vlookup with an Hlookup? Thanks.

vlookup and hlookup in the same formula
 

Teethless mama

I have tried using a formula, based on your suggestion below, but I'm
getting the column header instead of the cell value that I need.

This is what I have entered in cell AV4:
=INDEX(1:65536,MATCH(AU4,A12:A112,0),MATCH(AU3,A1: AT1,0))

AU4 is a client code that I need to find in range A12 to A112.
AU3 is the column header that I need to find in range A1:AT1 - cell AU3 has
a formula and will therefore update when other figures are updated.
T12 contains the result that I need.

Any suggestions?

"Teethless mama" wrote:

=INDEX(data range,MATCH("mama",A1:A100,0),MATCH("Labor Code y",A1:C1,0))

Adjust to suit


"lindsayhyle" wrote:

Hi,
I have a spreadsheet that I would like to pull data from a pivot table on a
different sheet. The data I have would need to pull from both the rows and
the columns. It would look like this:
Labor Code x Labor Code y Labor Code z
Name
Name
Name
Name

I would like the lookup to reference the name and the labor code from the
pivot table. Is there a way to combine a Vlookup with an Hlookup? Thanks.

vlookup and hlookup in the same formula
 

Resolved this now - referred to inaccurate data ranges.

"Sarah (OGI)" wrote:

Teethless mama

I have tried using a formula, based on your suggestion below, but I'm
getting the column header instead of the cell value that I need.

This is what I have entered in cell AV4:
=INDEX(1:65536,MATCH(AU4,A12:A112,0),MATCH(AU3,A1: AT1,0))

AU4 is a client code that I need to find in range A12 to A112.
AU3 is the column header that I need to find in range A1:AT1 - cell AU3 has
a formula and will therefore update when other figures are updated.
T12 contains the result that I need.

Any suggestions?

"Teethless mama" wrote:

=INDEX(data range,MATCH("mama",A1:A100,0),MATCH("Labor Code y",A1:C1,0))

Adjust to suit


"lindsayhyle" wrote:

Hi,
I have a spreadsheet that I would like to pull data from a pivot table on a
different sheet. The data I have would need to pull from both the rows and
the columns. It would look like this:
Labor Code x Labor Code y Labor Code z
Name
Name
Name
Name

I would like the lookup to reference the name and the labor code from the
pivot table. Is there a way to combine a Vlookup with an Hlookup? Thanks.

vlookup and hlookup in the same formula
 

Try this:

=INDEX(A1:AT112,MATCH(AU4,A1:A112,0),MATCH(AU3,A1: AT1,0))

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Sarah (OGI)" wrote in message
...
Teethless mama

I have tried using a formula, based on your suggestion below, but I'm
getting the column header instead of the cell value that I need.

This is what I have entered in cell AV4:
=INDEX(1:65536,MATCH(AU4,A12:A112,0),MATCH(AU3,A1: AT1,0))

AU4 is a client code that I need to find in range A12 to A112.
AU3 is the column header that I need to find in range A1:AT1 - cell AU3 has
a formula and will therefore update when other figures are updated.
T12 contains the result that I need.

Any suggestions?

"Teethless mama" wrote:

=INDEX(data range,MATCH("mama",A1:A100,0),MATCH("Labor Code y",A1:C1,0))

Adjust to suit


"lindsayhyle" wrote:

Hi,
I have a spreadsheet that I would like to pull data from a pivot table
on a
different sheet. The data I have would need to pull from both the rows
and
the columns. It would look like this:
Labor Code x Labor Code y Labor Code z
Name
Name
Name
Name

I would like the lookup to reference the name and the labor code from
the
pivot table. Is there a way to combine a Vlookup with an Hlookup?
Thanks.

vlookup and hlookup in the same formula
 

Thank you for your response.

I realised it was something to do with the references - I was getting abit
confused. All sorted now.

Thanks again.

"RagDyeR" wrote:

Try this:

=INDEX(A1:AT112,MATCH(AU4,A1:A112,0),MATCH(AU3,A1: AT1,0))

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Sarah (OGI)" wrote in message
...
Teethless mama

I have tried using a formula, based on your suggestion below, but I'm
getting the column header instead of the cell value that I need.

This is what I have entered in cell AV4:
=INDEX(1:65536,MATCH(AU4,A12:A112,0),MATCH(AU3,A1: AT1,0))

AU4 is a client code that I need to find in range A12 to A112.
AU3 is the column header that I need to find in range A1:AT1 - cell AU3 has
a formula and will therefore update when other figures are updated.
T12 contains the result that I need.

Any suggestions?

"Teethless mama" wrote:

=INDEX(data range,MATCH("mama",A1:A100,0),MATCH("Labor Code y",A1:C1,0))

Adjust to suit


"lindsayhyle" wrote:

Hi,
I have a spreadsheet that I would like to pull data from a pivot table
on a
different sheet. The data I have would need to pull from both the rows
and
the columns. It would look like this:
Labor Code x Labor Code y Labor Code z
Name
Name
Name
Name

I would like the lookup to reference the name and the labor code from
the
pivot table. Is there a way to combine a Vlookup with an Hlookup?
Thanks.