Lookup problem

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?
 
J

John Bundy

Sounds like you want to do a simple vlookup. Click the function key to the
left of your formula bar and do a search for it, the excel help is pretty
good with vlookups.
 
B

BoniM

Yes, there is...

=VLOOKUP(D2,Rates!$A$1:$B$13,2,0)
Enter in Markup column on the Data sheet.
D2 should be changed to the cell address of the first rows Category cell.
Copy down to the rest of the column.
As long as your table on the rates sheet is in the A1:B13 range, this should
do what you wanted...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top