MrExcel Publishing
Your One Stop for Excel Tips & Solutions

If ,Vlookup


Posted by L.E. Patton on December 24, 2001 1:05 PM

Need to select a product for production depending on what day of the week it is. On one sheet I have a Row labeled Monday Tuesday up to Saturday (no Sunday)The colums under each day holds a value or nothing for a product,ie: Prod No#|Description|Size|Monday|Tuesday|
1157| Orng Drnk| Pt| 0| 30,000|
On my production sheet(Same Book)Date is in A1, A2=A1 formated "dddd".Is there a formula that will look at cell A2 to see what day of the week it is, go to juice sheet find same product no# and look under the matching day for a number,


Posted by John on December 24, 2001 2:52 PM

if your product No is in A1 the date is in B1 then:

=VLOOKUP(A1,Juice!$A$2:$H$20,WEEKDAY(B1,2)+3,FALSE)