Forum Discussion
IFERROR VLOOKUP Formula Issue
Hi there, I really hope someone can help me out! The formula i have plugged in is: = IFERROR(VLOOKUP(D4,Rates!$K$4:$L$725,4,FALSE),"0")*F4 There are two sheets: sheet1 and Rates. ...
VLOOKUP's nature is to look left, return right unless you nest a function like CHOOSE to pick the column order.
Try this:
= IFERROR(VLOOKUP(D4,CHOOSE({1,2},Rates!$L$4:$L$8,Rates!$K$4:$K$8),2,0),0)*F4