Thanks for that. I have used VLOOKUP to populate a cell based on the selection of 1 drop down, but how do I use it to populate a cell based on the selection of 2 drop downs?
I have:
=VLOOKUP(b23,TentPrice,2,FALSE)

what is an example of modifying this formula to 'read' from 2 drop downs?

Thanks again, I appreciate your help.