Not sure if this will work, try
in D1
=IF(A1="","",LOOKUP(A1,{1,2,3},{3,"",7}))
in E1
=IF(A1="","",LOOKUP(A1,{1,2,3},{"",5,8}))
in F1
=IF(A1="","",LOOKUP(A1,{1,2,3},{4,6,9}))
Not sure if this will work, try
in D1
=IF(A1="","",LOOKUP(A1,{1,2,3},{3,"",7}))
in E1
=IF(A1="","",LOOKUP(A1,{1,2,3},{"",5,8}))
in F1
=IF(A1="","",LOOKUP(A1,{1,2,3},{4,6,9}))
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks