# Multiple If Formula

1. ## Multiple If Formula

Dear All,

One way doing is to do multiple vlook up against each column. Just wanted to know if we have another option with straight forward formula to arrive at the value in table 1?

image1.PNG

Tried with below,
``Please Login or Register  to view this content.``
Greatly appreciated if anyone knows way around!!

2. ## Re: Multiple If Formula

If I understand correctly, you could use INDEX/MATCH/MATCH.

Post a sample workbook. See the yellow banner at the top of the page.

3. ## Re: Multiple If Formula

Thanks TMS. added sample book.

4. ## Re: Multiple If Formula

Try this in Cell C2 and copy down:

=INDEX(Pivot!\$B\$2:\$G\$9,MATCH(\$A2,Pivot!\$A\$2:\$A\$9,0),MATCH(\$B2,Pivot!\$B\$1:\$G\$1,0))

5. ## Re: Multiple If Formula

Wow. Thank you so much. Helped my time on putting multiple Vlook up.

6. ## Re: Multiple If Formula

Hi,

Applied same logic to arrive at minimum value of header? Am i doing something wrong?

``Please Login or Register  to view this content.``

7. ## Re: Multiple If Formula

Try this

=MIN(INDEX(Pivot!\$B\$2:\$G\$9,,MATCH(\$B2,Pivot!\$B\$1:\$G\$1,0)))

8. ## Re: Multiple If Formula

Thank you.. Works pefect

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1