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