Paul Naylor
Board Regular
- Joined
- Sep 2, 2016
- Messages
- 98
- Office Version
- 365
- 2003 or older
- Platform
- Windows
- Mobile
- Web
Spreadsheet with order numbers Column B , and dates (dd/mm/yy) column F .
Separate spreadsheet which need to do vlookup on based on day i.e. Monday, Tuesday..... not sure how to do a vlookup on a cell B2 which contains say 17/11/20 to the equivalent date tab ( Tuesday ) on the other spreadsheet '[Refunds Week 28.xls]Tuesday'!
Anyone help?
Following formula:
=IF(ISERROR(IF(VLOOKUP($B2,'[Refunds Week 28.xls]Wednesday'!$A:$D,1,FALSE)=$B2,"True","Not Found")),"N",IF(VLOOKUP($B2,'[ Refunds Week 28.xls]Wednesday'!$A:$D,1,FALSE)=$B2,"Y","Not Found"))
Separate spreadsheet which need to do vlookup on based on day i.e. Monday, Tuesday..... not sure how to do a vlookup on a cell B2 which contains say 17/11/20 to the equivalent date tab ( Tuesday ) on the other spreadsheet '[Refunds Week 28.xls]Tuesday'!
Anyone help?
Following formula:
=IF(ISERROR(IF(VLOOKUP($B2,'[Refunds Week 28.xls]Wednesday'!$A:$D,1,FALSE)=$B2,"True","Not Found")),"N",IF(VLOOKUP($B2,'[ Refunds Week 28.xls]Wednesday'!$A:$D,1,FALSE)=$B2,"Y","Not Found"))