Cerca vert function

%3CLINGO-SUB%20id%3D%22lingo-sub-2710430%22%20slang%3D%22en-US%22%3ECerca%20vert%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2710430%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20All%2C%3C%2FP%3E%3CP%3Eit%20is%20a%20very%20simple%20function%2C%20but%20I%20really%20don't%20understand%20why%20it%20doesn't%20work.%3C%2FP%3E%3CP%3EAttached%20there%20is%20the%20excel%20file.%3CBR%20%2F%3EIn%20Sheet1%20there%20all%20all%20the%20data.%3C%2FP%3E%3CP%3EIn%20Sheet2%20there%20is%20the%20function%20to%20extract%20the%20values.%20In%20column%20A%20there%20are%20all%20the%20data%20interested.%20In%20colum%20C%20there%20is%20CERCA.VERT%20function.%20I%20want%20to%20find%20the%20value%20in%20column%20D%20in%20sheet1%20reletad%20to%20the%20interested%20data.%3C%2FP%3E%3CP%3EI%20don't%20know%20why%2C%20in%20any%20way%2C%20the%20fucntion%20extract%20thw%20wrong%20value%2C%20and%20in%20some%20cases%2C%20the%20correct%20one.%3C%2FP%3E%3CP%3ECan%20anyone%20help%20me%3F%3C%2FP%3E%3CP%3Ethank%20you%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2710430%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2710728%22%20slang%3D%22en-US%22%3ERe%3A%20Cerca%20vert%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2710728%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1144291%22%20target%3D%22_blank%22%3E%40Psala83%3C%2FA%3E%26nbsp%3BCorrected%20the%20formula%20for%20you.%20See%20if%20this%20is%20what%20you%20expect%20to%20see.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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!

2 Replies

@Psala83 Corrected the formula for you. See if this is what you expect to see.

Add an additional FALSE to your formula to make it an exact match; or use XLOOKUP if it is available to you.