Lookup/Match Problem

[NbrCruncher]

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.

 

[Niek Otten]

<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

|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.
|

 

[NbrCruncher]

<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


|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.

 

[Niek Otten]

Glad it works, thanks for the feedback!

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| > <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
| >
| >
| > |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.
|

 

[Guest]

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

Adjust to suit