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
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
test e8 first
Formula:Please Login or Register to view this content.Formula:Please Login or Register to view this content.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks