Look up two text values then multiply two cells based on the looked up text values

**monks_75** · 06-13-2012, 11:01 AM

Hi, new here so bare with the first question.

I am trying to create a formula (believe it will be an IF statement) that will look up the text value in one cell, then look up the text value in a second cell and then multiply two numeric values based on the text value. I have attached a spreadsheet with a note to show what I am looking for. Any help is greatly appreciated. Cheers

question.xlsx

**NBVC** · 06-13-2012, 11:05 AM

Try:

=B6*INDEX($J$6:$K$14,MATCH(C6,$I$6:$I$14,0),MATCH(D6,$J$5:$K$5,0))

copied down

**monks_75** · 06-13-2012, 11:20 AM

Thank you very much NBVC!

Look up two text values then multiply two cells based on the looked up text values

LinkBack

Thread Tools

Rate This Thread

Display

Look up two text values then multiply two cells based on the looked up text values

Re: Look up two text values then multiply two cells based on the looked up text values

Re: Look up two text values then multiply two cells based on the looked up text values

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions