I have a lookup/match problem that I cannot seem to get a solution
to.
I am assuming I can use a combination IF statement with a nested
VLOOKUP but it's not coming to me.

I have a table with three columns. Column A has values S01 to S08.
Column B has unique values but are associated with the values in
column A. Column C has the target values I am trying to populate in a
cell.


So the problem is that I need to match a Column A value with a column
B value to find the answer in column C. Please note that the values
in
Column A are duplicated multiple times depending on their
relationship
to the values in column B.


Any suggestions would be appreciated. Thanks.

<Column B has unique values but are associated with the values in column A

I don't know what that means.

But maybe you can concatenate the A and B values (use the CONCATENATE function or the & operator), both for the search argument
and in a separate column in your table, and use those in VLOOKUP.

If you need more help, provide more info about the contents of the cells and the required operations.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

wrote in message ups.com...
|I have a lookup/match problem that I cannot seem to get a solution
| to.
| I am assuming I can use a combination IF statement with a nested
| VLOOKUP but it's not coming to me.
|
| I have a table with three columns. Column A has values S01 to S08.
| Column B has unique values but are associated with the values in
| column A. Column C has the target values I am trying to populate in a
| cell.
|
|
| So the problem is that I need to match a Column A value with a column
| B value to find the answer in column C. Please note that the values
| in
| Column A are duplicated multiple times depending on their
| relationship
| to the values in column B.
|
|
| Any suggestions would be appreciated. Thanks.
|

On Mar 27, 1:35 pm, "Niek Otten" wrote:
<Column B has unique values but are associated with the values in column A

I don't know what that means.

But maybe you can concatenate the A and B values (use the CONCATENATE function or the & operator), both for the search argument
and in a separate column in your table, and use those in VLOOKUP.

If you need more help, provide more info about the contents of the cells and the required operations.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

wrote in oglegroups.com...

|I have a lookup/match problem that I cannot seem to get a solution
| to.
| I am assuming I can use a combination IF statement with a nested
| VLOOKUP but it's not coming to me.
|
| I have a table with three columns. Column A has values S01 to S08.
| Column B has unique values but are associated with the values in
| column A. Column C has the target values I am trying to populate in a
| cell.
|
|
| So the problem is that I need to match a Column A value with a column
| B value to find the answer in column C. Please note that the values
| in
| Column A are duplicated multiple times depending on their
| relationship
| to the values in column B.
|
|
| Any suggestions would be appreciated. Thanks.
|

Thanks Niek. I should have thought about that manner of solving the
problem. It worked.

Glad it works, thanks for the feedback!

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"NbrCruncher" wrote in message oups.com...
| On Mar 27, 1:35 pm, "Niek Otten" wrote:
| <Column B has unique values but are associated with the values in column A
|
| I don't know what that means.
|
| But maybe you can concatenate the A and B values (use the CONCATENATE function or the & operator), both for the search
argument
| and in a separate column in your table, and use those in VLOOKUP.
|
| If you need more help, provide more info about the contents of the cells and the required operations.
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| wrote in oglegroups.com...
|
| |I have a lookup/match problem that I cannot seem to get a solution
| | to.
| | I am assuming I can use a combination IF statement with a nested
| | VLOOKUP but it's not coming to me.
| |
| | I have a table with three columns. Column A has values S01 to S08.
| | Column B has unique values but are associated with the values in
| | column A. Column C has the target values I am trying to populate in a
| | cell.
| |
| |
| | So the problem is that I need to match a Column A value with a column
| | B value to find the answer in column C. Please note that the values
| | in
| | Column A are duplicated multiple times depending on their
| | relationship
| | to the values in column B.
| |
| |
| | Any suggestions would be appreciated. Thanks.
| |
|
| Thanks Niek. I should have thought about that manner of solving the
| problem. It worked.
|

=SUMPRODUCT(--(A1:A100="criteria 1"),--(B1:B100="criteria 2"),C1:C100)

Adjust to suit


" wrote:

I have a lookup/match problem that I cannot seem to get a solution
to.
I am assuming I can use a combination IF statement with a nested
VLOOKUP but it's not coming to me.

I have a table with three columns. Column A has values S01 to S08.
Column B has unique values but are associated with the values in
column A. Column C has the target values I am trying to populate in a
cell.


So the problem is that I need to match a Column A value with a column
B value to find the answer in column C. Please note that the values
in
Column A are duplicated multiple times depending on their
relationship
to the values in column B.


Any suggestions would be appreciated. Thanks.