how to auto populate one cell based on the selections of TWO drop downs?

Hi All.
I am a newbie at Excel, so please forgive my lack of knowledge of terminology. I have searched for 3 days now but can't find anything on my problem.
I have a sheet which has 2 drop downs.
One is to select the trailer, the other is to select the tent.
The price varies depending on which tent goes on which trailer.
I am hoping there is a way to have the price fill in automatically, based on which selections are made in the drop downs regarding tent and trailer.
Hopefully this is simple??
Any help greatly appreciated.
Thanks!!

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.

Thanks again. I have attached a sample of my sheet.
You can see on the invoice sheet that the user can select the camper trailer, and then the tent. The combinations and prices are on the sheet 'trailers & tents combo'. The price on the invoice sheet was working but I just deleted the sheet for trailer prices as it was not going to work.
Thanks for your assistance, greatly appreciated.

Hi again.

Woops, told you I was a newbie.
I have re attached the file, which should all work now, as far as I got it at least.
On the invoice sheet, the selection on the tent model shows prices, but the prices need to change depending on which trailer is selected in the drop down box above it.
I have 1 range, TentPrice, but don't think this is right (thats why I deleted it in the last file). I have set up another sheet with Trailer & Tents Combo which I think may be better.
I need to know how to set it up so that, for example, if someone selected a Seeker Camper Trailer, with a ST12KSS tent, the price would show in H23 as $5295 (as shown in the Trailer & Tents Combo).

Kind regards.

That is perfect!! You are amazing - thanks so much.
I just have one more question, is there a way to make the choices in the drop down list show only once? ATM seeker shows as many times as it is in the table, and the tent models repeat the same. I am trying to keep the list short and as user friendly as possible, with each option showing just once. I think this will have to do with how I lay out the table?
Any suggestions?
Thanks again.

Thanks again, this will be my reading today and tonight.
Kind regards.

I'm back!
Have read about dependent lists, got 2 up in my sheet. They are at B33 (trailer) and B34 (tent). These lists are made from the data in Camper Trailer Models sheet.
Now I'm back to where I began, getting the price to show up in (for this example)H34 dependent on what is selected from the lists just mentioned.
Can anyone help me understand this please? I have tried to go with oeldere's help before but I don't really understand what he did so I cant see why its not working. Please forgive my neewbieness!!
I have attached a NEW sheet containing the dependent lists.
Any help will be so appreciated. Thanks again.

Can anyone tell me what the last 2 numbers stand for in this:
=VLOOKUP(B22&" "&B23,'Trailers & Tents Combo'!C$2:D$27,2,0)

The '2' and the '0'?
columns? rows? if so, is '0' a column/row?

Thanks very much.

Hi

The 2 is the number of columns you are looking at after the search criteria.
the 0 which means FALSE gives you an exact match to given criteria
if the 0 was a 1 this means TRUE and gives the closest answer to given criteria
the citeria is the item you are searching for in the lookup

hope this helps

Hi

The 2 is the number of columns you are looking at after the search criteria.
the 0 which means FALSE gives you an exact match to given criteria
if the 0 was a 1 this means TRUE and gives the closest answer to given criteria
the citeria is the item you are searching for in the lookup

hope this helps

Thank you!! I appreciate you taking the time to explain this to me. Simple once pointed out. I'm now off to read up on HLOOKUP's.

Hi
You just need to remember Vlookup look down a table and a hlook up looks across a table
have attatched a spreadsheet that shows how each lookup works if you look at shhet 2 you can play with it and see how it works

Hi
Sorry forgot to add sheet 2 data is for vlookup and sheet 3 data is for hlookup

me bad

hope it helps