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

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