Urgently need Help with VlookUP

[GNai]

Team Need Urgent Help
Currently have a Spreadsheet listing all Projects in a Column, each Row is a Project. starting form Row A2 down to Column A25, along B1 through to M1 have Project Activities. B2 through to M2 have dates of activities.
My goal on a different sheet would like to Lookup the a Project for any date that are with 2 days of today and return the activity and date

example: Project = Building Kitchen. Two days from today Activity = Hang Cabinet - Date would be the real date

Thank you Team

 

[jasonb75]

Without a visual example, best guess would be (Change "Project" to the name of the project to search for).

=IFERROR(INDEX($B$2:$M$25,MATCH("Project",$A$2:$A$25,0),MATCH(TODAY()+2,$B$1:$M$1,0)),"No Match")

If you need to post an example, please use XL2BB, not screen captures or copy and paste.

 

[GNai]

Without a visual example, best guess would be (Change "Project" to the name of the project to search for).

=IFERROR(INDEX($B$2:$M$25,MATCH("Project",$A$2:$A$25,0),MATCH(TODAY()+2,$B$1:$M$1,0)),"No Match")

If you need to post an example, please use XL2BB, not screen captures or copy and paste.

 

[GNai]

Thank you for the quick response - I have added a mini excel - So i would search the Project and it would return the activity and date that is 2 days from today

 

[jasonb75]

See if this works when you edit the ranges to match your actual sheet.

=IFERROR(LOOKUP(TODAY()+2,INDEX($B$2:$M$25,MATCH("Project",$A$2:$A$25,0),0),$B$1:$M$1),"No match")

This is the best that I can do without the XL2BB sample that I asked for. I can't test the formula on a screen capture.

 

[GNai]

See if this works when you edit the ranges to match your actual sheet.

=IFERROR(LOOKUP(TODAY()+2,INDEX($B$2:$M$25,MATCH("Project",$A$2:$A$25,0),0),$B$1:$M$1),"No match")

This is the best that I can do without the XL2BB sample that I asked for. I can't test the formula on a screen capture.

Wow it return the activity (Place Order), how can I also return the real date which would be 8th Aug - Thanks in advance - you are so prompt and a Champ

 

[jasonb75]

how can I also return the real date which would be 8th Aug

See if this works

=IFERROR(LOOKUP(TODAY()+2,INDEX($B$2:$M$25,MATCH("Project",$A$2:$A$25,0),0)),"No match")

Note that I've set both formulas so that if there is no exact match for the date 2 days from today then it will return the closest one before that date, not after.

 

[GNai]

See if this works

=IFERROR(LOOKUP(TODAY()+2,INDEX($B$2:$M$25,MATCH("Project",$A$2:$A$25,0),0)),"No match")

Note that I've set both formulas so that if there is no exact match for the date 2 days from today then it will return the closest one before that date, not after.

Jason it works - Your support so appreciated - thank you

 

[GNai]

See if this works

=IFERROR(LOOKUP(TODAY()+2,INDEX($B$2:$M$25,MATCH("Project",$A$2:$A$25,0),0)),"No match")

Note that I've set both formulas so that if there is no exact match for the date 2 days from today then it will return the closest one before that date, not after.

Hi Jason a very quick one - how can i return the date and instead o the number representing the date

 

[jasonb75]

Change the cell format to date.