Hi hansdecocq,
Assuming that you have the values in the A1, A2 & A3 cells.
You can have the percentile of these from formula [=150/MAX(A1:A3)]
Hope this helps.
Thanks.
Hi Raju,
If have understood your requirement correctly then, below is the suggestion-:
Now if you want to see the combination of all 4 columns then you can use the formula(=A2 & B2 & C2 & D2) in the "E2" cell.
Similarly, if you want to write the VBA code then it will be-...
Hi Adnan,
It will be great if you can share your requirement in bit details, like you can tell us about the which column in your excel file have what value.
Will definitely help you with vlook and all.