Sep 02 2021 01:00 AM
Dear All,
it is a very simple function, but I really don't understand why it doesn't work.
Attached there is the excel file.
In Sheet1 there all all the data.
In Sheet2 there is the function to extract the values. In column A there are all the data interested. In colum C there is CERCA.VERT function. I want to find the value in column D in sheet1 reletad to the interested data.
I don't know why, in any way, the fucntion extract thw wrong value, and in some cases, the correct one.
Can anyone help me?
thank you in advance!
Sep 02 2021 01:52 AM
@Psala83 Corrected the formula for you. See if this is what you expect to see.
Sep 02 2021 01:54 AM