Vlookup to tab another spreadsheet based on value cell

Paul Naylor

Board Regular
Joined
Sep 2, 2016
Messages
59
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"))
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

mamady

Board Regular
Joined
Sep 23, 2011
Messages
228
Office Version
  1. 365
Platform
  1. Windows
Hi Paul,

Can you please share a sample of your data set using XL2BB? it would be easier for us to understand the data structure and format, and accordingly recommend the formula.

Best Regards
 

Paul Naylor

Board Regular
Joined
Sep 2, 2016
Messages
59
Hi Paul,

Can you please share a sample of your data set using XL2BB? it would be easier for us to understand the data structure and format, and accordingly recommend the formula.

Best Regards
Hi Margaret,

Sure away Laptop moment will send it to you later tonight

Kind Regards,

Paul
 

Watch MrExcel Video

Forum statistics

Threads
1,127,685
Messages
5,626,293
Members
416,172
Latest member
lordposh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top