Pricing Grid Lookup Help

[mrkris2010]

I have a cell that is the cost per hour that I'd like to pull in from another sheet. That value will be based on the number of people, month, day of week and number of trucks for which I have a full grid for.

In the above scenario, I want the highlighted cell to do a lookup on the Hourly Rate Grid and it would pull in the cost where August, Sunday, 2 laborers and 1 truck intersect. The grid looks like this:

How can I get the $164 value automatically pulled into the highlighted cell in the first image?

Thank you in advance for your expertise!

 

[hagia_sofia]

Please test this:

=XLOOKUP(N3,D2:J2,FILTER(D12:J22,(C12:C22=N2)*(A12:A22=N5)*(B12:B22=N6)))

where N3 = day of the week, N2 = month, N5 = laborers, N6 = trucks (adjust accordingly)

 

[mrkris2010]

Please test this:

=XLOOKUP(N3,D2:J2,FILTER(D12:J22,(C12:C22=N2)*(A12:A22=N5)*(B12:B22=N6)))

where N3 = day of the week, N2 = month, N5 = laborers, N6 = trucks (adjust accordingly)

The pricing grid is on a separate worksheet called Hourly Pricing Grid - how does the lookup know to look at that worksheet?

As-is, when I pasted the XLOOKUP on Sheet1 (the form), it put 5 vertial 0's. Here is sheet 1 where 7K has the formular you provided.

 

[hagia_sofia]

Something like this then:

=XLOOKUP(K3,'Hourly Pricing Grid'!D2:J2,FILTER('Hourly Pricing Grid'!D12:J22,('Hourly Pricing Grid'!C12:C22=K2)*('Hourly Pricing Grid'!A12:A22=K5)*('Hourly Pricing Grid'!B12:B22=K6)))