I need a formula in E2 that I can copy down the page that looks up the day number from the date in column C and then the company name in column D and then matches it to the company and day numbers found in the chart to pull out the drivers name.
I need a formula in E2 that I can copy down the page that looks up the day number from the date in column C and then the company name in column D and then matches it to the company and day numbers found in the chart to pull out the drivers name.
Here's one way
in C2
=INDEX(INDIRECT(LOOKUP(D2,{"AIRX","POSTIT","SHIPEX","ZIPPO"},{"I$12:J$16","G$12:H$16","G$20:H$24","I$20:J$24"})),WEEKDAY(C2)-1,2)
and copy down
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Why is cell K2 not working for POSTIT? POSTIT does not seem to work in the attached.
K2 does not contain the formula I posted.
LOOKUP needs to be in alphabetical order.
You've swapped round POSTIT and AIRX
It should be in this order.
AIRX,POSTIT,SHIPEX,ZIPPO
(You'll need to swap round the second set of table ranges as well)
Sounds good. I just posted one last thing in the macros section to do a function macro to convert celsius to fahrenheit. Can you answer that one.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks