Hey,

I am trying to get excel to look up a value in a sheet based on a combination of 4 drop-down lists. What I have is a series of different formulations which consist of different particles, different particle addition, different fluids combinations and different levels of fluid combinations.

eg: A B C D E
formulation 1: 0.02 % Gravel in 0.1% Petrol W
formulation 2: 0.01 % Gravel in 0.1% Petrol X
formulation 3: 0.1 % Gravel in 0.1% Petrol Y
formulation 3: 1 % Gravel in 1% Petrol Z


What I want is, when I select a particular combination of columns A, B, C, D, for excel to then return the values in Column E

I hope this explanation makes sense

I have tried the VLOOKUP function, but I can't see how to make it lookup more than one column

If anyone has an idea how to do this it would be great

Cheers