# uggg N/A Help

1. ## 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

2. ## Re: uggg N/A Help

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))))),"")

3. ## Re: uggg N/A Help

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

4. ## Re: uggg N/A Help

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))))),"")

5. ## Re: uggg N/A Help

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))))),"")

6. ## Re: uggg N/A Help

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)))),"")

7. ## Re: uggg N/A Help

Hi,

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

8. ## Re: uggg N/A Help

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

9. ## Re: uggg N/A Help

test e8 first
Formula:
`Please Login or Register  to view this content.`
Formula:
`Please Login or Register  to view this content.`

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1