Hi all
I don't think you can nest IFERROR, unfortunately, so here's what I'm trying to do:
A B C
1 54.6 #N/A #N/A
2 #N/A 44.1 #N/A
3 #N/A #N/A 78.9
IF there is a value in column A return that value, however, if there is an error, return the value in column B. Additionally if there are errors in both columns A AND B return the value in column C.
Any ideas?
SA
Last edited by SAsplin; 03-09-2012 at 07:53 AM.
If it is just numbers, try
=LOOKUP(99^99,A1:C1)
=IF(NOT(ISNA(A1)),A1,IF(NOT(ISNA(B1)),B1,IF(NOT(ISNA(C1)),C1,"")))
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
That's amazing! Works a treat. How is that working?
Both solutions work a treat! Many thanks guys!
SA
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks