enter matching value in a sheet, based on small data from another sheets

[YansaneYansane]

Hi Tech,

Would welcome and could use any help..

Trying to figure out how to use formula to enter matching value in a sheet, based on small data from another sheets.

Please see attached..

 

[YansaneYansane]

Hello,

You are correct. I do not have have English names of functions.

I have a "French" version of Excel. I could not adapt the formulas.

Thank you

So namely - what is expected to be in F3 in sheet1 . This cell as I understand id described as TRANSIT (in column D) and VALIDE (in column E).

The only difference is extra row in header of a sheet1 so instead of

=XLOOKUP(D2,Sheet2!$C$3:$C$13,Sheet2!$A$3:$A$13,"not found",0)

shall be used:

=XLOOKUP(D3,Sheet2!$C$3:$C$13,Sheet2!$A$3:$A$13,"not found",0)

and so on.

Or may be you don't have english names of functions?

 

[Kaper]

So the first formula probably will be:

=RECHERCHEX(D3,Sheet2!$C$3:$C$13,Sheet2!$A$3:$A$13,"not found",0)

may be also with semicolons instead of commas ? it depends on local settings. (I think different in Canada (comma) than in France (semicolon))

To translate formulas you can use free online tool here: Translator

 

[YansaneYansane]

Hi....

A thousand thanks. It worked.
The Excel Calculator was also extremely useful...

 

[Kaper]

Glad to hear that.