How do you add items from a drop down box to a IF statement? Example:
Drop Down Box: 1,2,3,4,5
I tired something similar to this formula: IF(A1="1,2,3,4,5",Vlookup(B1,C1:D5,2,FALSE))
How do you add items from a drop down box to a IF statement? Example:
Drop Down Box: 1,2,3,4,5
I tired something similar to this formula: IF(A1="1,2,3,4,5",Vlookup(B1,C1:D5,2,FALSE))
Maybe something like this...
=IF(OR(A1={1,2,3,4,5}),VLOOKUP(B1,C1:D5,2,0),"")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Works for me.
Maybe this version:
=IF(OR(A1={"1","2","3","4","5"}),VLOOKUP(B1,C1:D5,2,0),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks