If Then, maybe?

[kpro]

I am trying to pull the information from my "WK" sheet to the corresponding presentation "Manifest" sheet. The "Manifest" sheet will need to update daily with the information of the matching date.
i.e. The date in the "Manifest" sheet is 12/26/22. The information needs to pull from the "WK" sheet under the matching date in the matching columns.

I have tried to use =VLOOKUP(H3,'WK 12.26'!A1:AT51,2,FALSE) but can not get the information to pull up.

 

[Max1616]

Hello, I'm not 100% certain which value you are trying to return, but try something like this:

=INDEX('WK 12.26'!A:BZ,3,MATCH(H3,'WK 12.26'!1:1,0)+2

=INDEX('WK 12.26'!A:BZ,3,MATCH(H3,'WK 12.26'!1:1,0)+2
The assumption here is that the date fields match.

Where this will return the 3rd row down from the date match, and 2 columns in from the date match.

• This should return the Cust# 102236 for 12/26/2022
• This should return the Cust# 1341 for 12/27/2022

This formula here will find the column in which your date match exists:

=MATCH(H3,'WK 12.26'!1:1,0)

Then you can use index to pull the specific row you want for the column found in the formula above.

I hope this helps!