HLOOKUP with VLOOKUP into different Doc

[freeman]

First I need to know if it is possible...

What I have is a spread sheet that uses a color system, that color system relates to a process and is colored when a qty is needed on a specific day based on the level of inventory.



So, if inventory can cover shipping the field isn't colored however if the qty isn't enough to meet that qty the next shipping date is colored.

Is it possible to do an =if with colors then do a lookup of the date in the header column then do a vlookup with that information into a new document.

The idea is I need to find a part, the day it is colored and then the date corresponding to the day it is colored then migrated into another sheet with the same part number.