I know there is probably an answer out there already. However, I do not have the time to search. But if there is already a post out there and it answers this, please tell me! Thanks! I'll describe what I want and I have attached a basic worksheet. The workbook I am building is several sheets and this will be a hidden, non-editable sheet and I can just reference the cell with the info in the hidden sheet for my working sheet. Hope that makes sense.
I want to have a couple drop down menus using Data Validation to populate permit cost for a specific county. There are several counties and each county varies price wise, but the types of permits stay the same. I would like it to read something like this: "if [drop down cell] equals [county] and if [drop down cell] equals [type of permit], then return mark up cost for said feeder in said county. I'm not sure if and "IF" statement is what I should use, or vlookup or something. Just don't know how to formulate it. I saw some info on tables, but have never used them before, and not sure how to fit in 10+ tables into a formula. Any info is appreciated! I'm still learning everyday, so please be gentle
Bookmarks