How do I add a statment to this formula to say:
If I5 is blank, do nothing...otherwise do what the code says below?
I tried adding it in different ways but it doesn't work.
=IF(ISNA(MATCH(I5,code,0)),"-",INDEX(description,MATCH(I5,code,0)))
How do I add a statment to this formula to say:
If I5 is blank, do nothing...otherwise do what the code says below?
I tried adding it in different ways but it doesn't work.
=IF(ISNA(MATCH(I5,code,0)),"-",INDEX(description,MATCH(I5,code,0)))
=IF(I5="","",IF(ISNA(MATCH(I5,code,0)),"-",INDEX(description,MATCH(I5,code,0))))
AWESOME! Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks