Lookup and Match Formula

[CarlW1179]

Hi

I'm looking to find formula to return a value in sheet 2 after searching for a specific product code and month in sheet 1 and matched to the date in sheet 1


for example find the price paid for an ingredient in October 24

Thanks in advance

 

[HighAndWilder]

Hi

I'm looking to find formula to return a value in sheet 2 after searching for a specific product code and month in sheet 1 and matched to the date in sheet 1


for example find the price paid for an ingredient in October 24

Thanks in advance

View attachment 118720



View attachment 118719

Are the values in the range F1:J1 actual dates and if so what date within the month?

The first of the month is often used for this type of application.

Same question about the E1 date?

 

[CarlW1179]

Are the values in the range F1:J1 actual dates and if so what date within the month?

The first of the month is often used for this type of application.

Same question about the E1 date?

Hi

No the values are the what I am trying to pull through to the other sheet.

using the date in F1 so effectively what i would do is change the month in the blue cell on the first sheet and it would pull thought the values for the RJL Codes A2:A12

Cheers

 

[ThatOneDude]

Place this in cell E2 on Sheet 2 and see if this works for you. If so, drag it down to fill the rest of the E column. You'll just need to adjust the first range "Sheet1!$F$2:$J$10" to encompass your full data set.
=IFERROR(INDEX(Sheet1!$F$2:$J$10, MATCH($A2, Sheet1!$D:$D, 0), MATCH(E$1, Sheet1!$A:$A, 0)), "Not Found")

 

[CarlW1179]

Place this in cell E2 on Sheet 2 and see if this works for you. If so, drag it down to fill the rest of the E column. You'll just need to adjust the first range "Sheet1!$F$2:$J$10" to encompass your full data set.
=IFERROR(INDEX(Sheet1!$F$2:$J$10, MATCH($A2, Sheet1!$D:$D, 0), MATCH(E$1, Sheet1!$A:$A, 0)), "Not Found")

That looks like its worked.

Thanks you for that really appreciate it.

 

[ThatOneDude]

Awesome! Glad I could help!