Thread: How do I make the true return a drop down list in the IF function?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey
 
Posts: n/a
Default How do I make the true return a drop down list in the IF function?
Please don't use ALL caps - it's like shouting

Use

=vlookup(B10, D1:E15,2,false)

where D1:E15 is a table of dropdown items (left column) and Twill Shirt &
other results (right column)

"Brian" wrote:

=IF(B10="TWILL SHIRT",M2,0)

B10 IS A DROP DOWN LIST. I WOULD LIKE TO HAVE THE TRUE RETURN BE DIFFERENT
DROP DOWN LISTS CORRESPONDING TO EACH ITEM IN B10.
Reply With QuoteReply With Quote