VLookUp
Hi
Tanks for both of you, its working now.
Best Regards
Toppers a écrit :
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
|