I need to autopopulate cells based on data that is selected via drop down in 2 different cells. Based on what you select in the first cell and what you select in the second cell, a specific value is returned.
I'm using this formula to autopopulate based on what is in one cell and that is working fine:
=IF(ISBLANK(P3),"",VLOOKUP(P3,costdata,2,0))
However, I think I need an "AND" function somewhere, because I need it to look at cell P3 and cell N3 and then return a certain value based on both of those fields.
Thanks for any assistance you can provide!
Bookmarks