You could use VLOOKUP, but you will have to concatenate your four
columns into one in your main table. Assume this is on Sheet1 - just
insert a new column E and enter this formula in E1:

=A1&B1&C1&D1

and copy this down the new column E. Then your VLOOKUP formula in the
other sheet would look something like:

=VLOOKUP(A3&B3&E3&D3,Sheet1!E$1:F$1000,2,0)

where I am assuming you enter data values on row 3 of your second
sheet and that you have up to 1000 different values in your main table
on Sheet1.

Hope this helps.

Pete

On Jul 23, 2:54 pm, 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