Can someone explain why this is not working
V5 is the link cell to a combo box. Based on the value of that cell (V5)
I want to be able to vlook up the name associated with it.
Except i want that value to come from I3 if the value in cell (v5) is 1,9,or17
Right now, even if the value in V5 is 1, it still doing the vlookup instead of making it the value of I3 :S
=IF(V5=(OR(1,9,17)),I3,VLOOKUP(V5,$AL$1:$AO$32,3,FALSE))
Please help.. Thanks !
Bookmarks