LinkBack URL
About LinkBacks
I have set if all things fail/ FALSE, it should produce result "accessories" so why is it still showing #N/A? I'm yanking my hair out!
I have set if all things fail/ FALSE, it should produce result "accessories" so why is it still showing #N/A? I'm yanking my hair out!
its probably one of the results set is not correct
and IFERROR ( formula, "result if error") maybe the way to go
i would test each one of your IF tests and see what happens
you are not testing for the result to not return any result
for example
=VLOOKUP('Q1''13 Supporting'!$P19,Lists!$T$2:$U$29,2,FALSE)
returns a #N/A
so does
=MATCH('Q1''13 Supporting'!$P19,Lists!$T$2:$T$29,0)
and so thats not true or false
Not sure about which column formula you are talking about
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
When the MATCH formula doesn't find a match, you get an error. Instead try:
=IF($I21>25000,"Systems",IF('Q1''13 Supporting'!$P19="","Accessories",IFERROR(IF(MATCH('Q1''13 Supporting'!$P19,Lists!$T$2:$T$29,0),VLOOKUP('Q1''13 Supporting'!$P19,Lists!$T$2:$U$29,2,FALSE)),"Accessories")))
<--- If you like the answer, press *.
I was thinking that the formula is smart enough to know that if it doesn't match then it reflects "Accessories"
However it returns N/A if there's no match.
Thanks zumbalj ! It worked great and resolved the issue with the red cell! Cheers! You are a genius!
Thanks! Glad to be of helpRemember to mark your thread solved, and if you feel so inclined, press the * on the left side to add to my reputation.
Hi zumbalj, I have clicked the *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks