I feel like this is simple but I am missing something very easy here.
I am trying to plug in a formula which basically says IF a cell = something then vlookup, but i need to do this multiple times.
So for example the cell is a drop down with 3 options, so if it says "blue" then the vlookup is based of blue tab, but if it says "red" its based of a red tab.
this is what i have right now but am getting #value
=IF($A$3="Sales",VLOOKUP(A5,Sales!$A$43:$I$67,9,FALSE),"no")*$D$1,IF($A$3="Risk",VLOOKUP(A5,Fixed_Risk!$A$43:$I$67,9,FALSE),"no")*$D$1
thanks all
Bookmarks