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..

 

[dreid1011]

We will need to see the other sheets and have more information on how you trying to match data to pull the fees in. Otherwise, those two images tell us nothing.

 

[YansaneYansane]

We will need to see the other sheets and have more information on how you trying to match data to pull the fees in. Otherwise, those two images tell us nothing.

Hi Tech,

Thanks for the prompt reply... Here's the second sheet. Thanks for 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]

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

FYI, I did not receive any answer nor solutions. I'll click and mark it as soon as I get a solution "Mark as solution" button " Thanks.
I had to send a screenshot since the Excel file was seemingly too large to be sent. The files are re-attached above .

 

[YansaneYansane]

We will need to see the other sheets and have more information on how you trying to match data to pull the fees in. Otherwise, those two images tell us nothing.

Hi;

I have resent the second sheet... Thanks

 

[Kaper]

I've originaly posted an answer in the duplicated thread, and it is lost, because thread was closed

Basically i proposed something like for F2 in main sheet (the one with yellow arrow):

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

or

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

or

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

the formulas are for fee depending on type, status and type & status respectively.

They were prepared assuming your reference sheet is called Sheet2 and screenshot of it starts at column A

 

[YansaneYansane]

Hi Kaper,

Apologies for that. Your solutions had been deleted for "double posting" before I had seen them. Thx.

Yet, the f(x) you sent are not working with my FILE (I could quickly confirm this link).

Loading Google Sheets

 

[Kaper]

I cant check it, as I don't have rights to open your google sheets.
When you are posting screenshots do it that way, that column letters and row numbers are visible and identify sheet name (or include tab with sheetname in the screenshot.
My solution was for setup as on attached edited screenshots, and all 3 formulas to be tested in F2. 3 different formulas, because you gave no description how value in that cell shall be calculated).

Note that miniatures may look similar, but the screenshots were edited and row and columns were added

 

[YansaneYansane]

I cant check it, as I don't have rights to open your google sheets.
When you are posting screenshots do it that way, that column letters and row numbers are visible and identify sheet name (or include tab with sheetname in the screenshot.
My solution was for setup as on attached edited screenshots, and all 3 formulas to be tested in F2. 3 different formulas, because you gave no description how value in that cell shall be calculated).

Note that miniatures may look similar, but the screenshots were edited and row and columns were added

Hi,

Thanks much for your tremendous help and clarifications. Find screenshots below for Sheet1 and Sheet2, with displayed rows, columns, and tabs.

The Looked Up was to return exact matching values. The matched values are not calculated, but simply returned or displayed as value. Thanks again.

 

[Kaper]

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?