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: