Hi I need a forumla that does the following please.
If cell P2 = N/A then vlook upworksheet 2, d18:E32, return 2nd col, if cell P2 does not have N/A, then vlook up worksheet 2, d2, e18 return the 2nd col.
Any ideas how to do this please?
Thanks
Hi I need a forumla that does the following please.
If cell P2 = N/A then vlook upworksheet 2, d18:E32, return 2nd col, if cell P2 does not have N/A, then vlook up worksheet 2, d2, e18 return the 2nd col.
Any ideas how to do this please?
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks