Assume columns A:D are your reference columns and E is your data column:

=INDEX(E2:E100,MATCH(1,(A2:A100=ref1)*(B2:B100=ref 2)*(C2:C100=ref3)*(D2:D100=ref4),0))

Enter with Ctrl+Shift+Enter (you will get {} round the formual if entered
correctly)

where ref1 to ref4 are your values to compared.

Put these in cells:

e.g. in X1 to X4

=INDEX(E2:E100,MATCH(1,(A2:A100=X1)*(B2:B100=X2)*( C2:C100=X3)*(D2:D100=X4),0))

HTH

"Nabil" wrote:

HelloI'm new in Excel macro and functions, so I have a sheet with a
several columns (4) columns.
I have to find the referneces in the 4 columns and get the
corresponding data in the fifth coolumn.
Is it possible to do it with the VLookUp? Or there are another way?
Regards