M
murrmeik
I have a two-column worksheet containing the following data; column A
(Category) contains 12 text values and column B (Markup) contains 12 related
text values. This table resides on a separate worksheet named "Rates". My
main worksheet, named "Data", contains several thousand records of about 20
columns each; two columns in this worksheet are also labeled "Category" and
"Markup".
For each record in the Data worksheet, the Category column contains one of
the 12 possible values found in the Category column of the Rates worksheet,
and the Markup column is blank. I want to place a formula in each cell in
the Markup column of the Data worksheet that looks in the Category column of
the Rates worksheet to find the value that matches the value in the Category
column of the Data worksheet, and when the match is found, places into the
Markup column of the Data worksheet the corresponding Markup value found in
the Rates worksheet.
Is there a formula that will do this?
(Category) contains 12 text values and column B (Markup) contains 12 related
text values. This table resides on a separate worksheet named "Rates". My
main worksheet, named "Data", contains several thousand records of about 20
columns each; two columns in this worksheet are also labeled "Category" and
"Markup".
For each record in the Data worksheet, the Category column contains one of
the 12 possible values found in the Category column of the Rates worksheet,
and the Markup column is blank. I want to place a formula in each cell in
the Markup column of the Data worksheet that looks in the Category column of
the Rates worksheet to find the value that matches the value in the Category
column of the Data worksheet, and when the match is found, places into the
Markup column of the Data worksheet the corresponding Markup value found in
the Rates worksheet.
Is there a formula that will do this?