Vlookup with multiple requirements

[Ohrdhor]

Hey I'm trying to design a VLOOKUP formula that will look at cells D12, E12, F12, and G12, and use the table B2:F209, and the formula spit out what is in column 5, but unfortunately I can't get it to work, can anyone tell me the specific formula to use?

Thanks a lot guys!

 

[VoG]

Do you mean that you want to concatenate 4 columns

=VLOOKUP(D12&E12&F12&G12,B2:F209,5,FALSE)

 

[Ohrdhor]

No, I want it to match criteria from them as I have repeated values in some of the columns. I tried pretty much exactly what you posted before I made this post and all it spits out is a #N/A, I'm not sure if vlookup is the tool for this job, and if not, would something else work?