How can I create a multiple IF statement and a multiple VLOOKUP within the same formula

**azumi** · 08-11-2014, 04:06 AM

Maybe
=IF(OR(I15="BUTT CUT",I15="DIECUT"),VLOOKUP(J15,V13:Z22,2,FALSE),"")

**BASH1001** · 08-11-2014, 04:33 AM

Nearly there it work with regards to BUTT CUT but not when I switch my selection to DIE CUT.

I will try to send you spreadsheet but I am struggling to see how on this forum.

**azumi** · 08-11-2014, 04:39 AM

to attach your sample workbook, click "Go Advanced" button and find Paperclip Button to attach the file

Regards

How can I create a multiple IF statement and a multiple VLOOKUP within the same formula

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: How can I create a multiple IF statement and a multiple VLOOKUP within the same formul

Re: How can I create a multiple IF statement and a multiple VLOOKUP within the same formul

Re: How can I create a multiple IF statement and a multiple VLOOKUP within the same formul

Thread Information

Users Browsing this Thread

Similar Threads

How do I create a mulitple IF statement and multiple VLOOKUP with same formula.

[SOLVED] multiple vlookup + and statement

[SOLVED] create a macro to to vlookup multiple values

Create an IF statement for multiple crews

Create a nesting formula w/ multiple conditions based on fields w/VLOOKUP

Bookmarks

Bookmarks

Posting Permissions