IF VLOOKUP Formula

[Roger509]

Hi,

I'm trying to do an IF VLOOKUP formula in column D. If there is a 1 in column A, I want the vlookup to pull from the FRUITS table (J3:K21). If there is a 1 in column B, I want the vlookup to pull from the VEGETABLES table (J26:K44). This formula returns the correct ACCT when there is a 1 in column A, but not when there is a 1 in column B (cell D4 & D8). I tried putting an IFERROR vlookup in the first part of the formula, but got no results, so I removed it. Also have 2 supplemental objectives on the attachment (labeled 2 & 3 on rows 14 & 15), but not as high-priority as the request listed here.

Thank you, any help is much appreciated.

[Limor_OP]

Hi
Try this in D2:
=IFERROR(IF(A2=1,VLOOKUP(C2,$J$3:$K$21,2,0),IF(B2=1,VLOOKUP(C2,$J$26:$K$44,2,0),"")),IF(A2=1,179,IF(B2=1,279)))

[samba_ravi]

or try below formula

=IFERROR(VLOOKUP(C2,IF(A2=1,$J$3:$K$21,IF(B2=1,$J$26:$K$44)),2,0),"")

[Roger509]

Works perfectly, thank you so much.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.