Need IF statement help

DAWG2006

Board Regular
Joined
Feb 15, 2009
Messages
86
What can I do with this?

=IF(A4="Select",0,IF(A4=OR(AD8,AD9,AD10,AD11,AD12,AD13,AD14,AD15,AD16,AD17,AD18),"MOVIE",IF(A4=OR(AD19,AD20,AD21,AD22,AD23,AD24,AD25,AD26),"TV")))
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
wrap it up nicely & give it to someone for their birthday?

Seriously - what's your question?
 
Upvote 0
Good one,

It's just giving me a VALUE error and I don't know how to fix it.

I trying to get the cell to say MOVIE or TV when someone selects a title form a drop down list. Of course not randomly but have it show MOVIE or TV based of a list.
 
Upvote 0
That seems to work, not sure this is really any better:

=IF(A4<>0,LOOKUP(MATCH(A4,AD8:AD26,0),{1,12},{"Movie","TV"}),"Select")

A VALUE# error would mean it can't find the title in your listing in column AD. Perhaps some stray spaces in there.
 
Last edited:
Upvote 0
wrap it up nicely & give it to someone for their birthday?
:ROFLMAO:

I'm hazarding a guess that perhaps you want this:
=IF(ISNA(MATCH(A4,AD8:AD18,0)),IF(ISNA(MATCH(A4,AD19:AD26,0)),"Select","TV"),"MOVIE")
 
Upvote 0
Anticipation...
Hehehe, me thinks we should introduce a twiddling thumbs smiley :)


Ok, I will comment on the one I supplied:

=IF(ISNA((1)MATCH(A4,AD8:AD18,0)),IF(ISNA((2)MATCH(A4,AD19:AD26,0)),(3)"Select",(4)"TV"),(5)"MOVIE")

(1) The 1st MATCH:
-> Look for A4 value within range AD8:AD18

(2) If it isn't there then go to the 2nd MATCH:
-> Look for A4 value within AD19:AD26

(3) If A4 is not found in either MATCH (1) or (2) then return "Select"
(4) If A4 is found in the range in step (2) then return "TV"
(5) If A4 is found in step (1) then return "MOVIE"
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,202
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top