uggg N/A Help

I need help getting rid of the 'false' or 'N/A' everything works fine they just annoy me... a lot!

=IF(E8=ULINE,VLOOKUP(B8,AUTOFILL!$E:$G,3),IF(E8=ECONOBOX,VLOOKUP(B8,AUTOFILL!$I:$K,3),IF(E8=ALLIANCE,VLOOKUP(B8,AUTOFILL!$M:$O,3))))

thank you

Use iferror

=IFERROR(IF(E8=ULINE,VLOOKUP(B8,AUTOFILL!$E:$G,3),IF(E8=ECONOBOX,VLOOKUP(B8,AUTOFILL!$I:$K,3),IF(E8=ALLIANCE,VLOOKUP(B8,AUTOFILL!$M:$O,3))))),"")

THANKS! that got rid of the N/a how do i make the false not show up.

I know it's getting bigger, scratching my head for simpler solutions Till i get that, try this

=IFERROR((IF(IF(E8=ULINE,VLOOKUP(B8,AUTOFILL!$E:$G,3),IF(E8=ECONOBOX,VLOOKUP(B8,AUTOFILL!$I:$K,3),IF(E8=ALLIANCE,VLOOKUP(B8,AUTOFILL!$M:$O,3)))))="FALSE","",(IF(E8=ULINE,VLOOKUP(B8,AUTOFILL!$E:$G,3),IF(E8=ECONOBOX,VLOOKUP(B8,AUTOFILL!$I:$K,3),IF(E8=ALLIANCE,VLOOKUP(B8,AUTOFILL!$M:$O,3))))),"")

Small fix. try this

=IFERROR((IF(IF(E8=ULINE,VLOOKUP(B8,AUTOFILL!$E:$G,3),IF(E8=ECONOBOX,VLOOKUP(B8,AUTOFILL!$I:$K,3),IF(E8=ALLIANCE,VLOOKUP(B8,AUTOFILL!$M:$O,3)))))=FALSE,"",(IF(E8=ULINE,VLOOKUP(B8,AUTOFILL!$E:$G,3),IF(E8=ECONOBOX,VLOOKUP(B8,AUTOFILL!$I:$K,3),IF(E8=ALLIANCE,VLOOKUP(B8,AUTOFILL!$M:$O,3))))),"")

This didn't work. no n/a but still false. here is the what is currently work. I just want the cell to be blank when nothing is slected.

=IFERROR(IF(E8=ULINE,VLOOKUP(B8,AUTOFILL!$E:$G,2),IF(E8=ECONOBOX,VLOOKUP(B8,AUTOFILL!$I:$K,2),IF(E8=ALLIANCE,VLOOKUP(B8,AUTOFILL!$M:$O,2)))),"")

Hi,

Please upload a sample excel sheet ( with dummy data if sensitive). It will be easy to sort it out.

test box.xlsx

B8 thru B21 are drop downs that auto fill C&D 8 thru C&D 21 that side works

E8 has an if statement and now i can't get it to work right

E8 thru E21 should auto fill F&G 8 thru F&G 21 and that is where the false comes in.

Also since you are able to do this, J8 thru J21 has $0.00, is thre a way to get rid of that if nothing is filled in as well?

THANK YOU SO MUCH