troubleshooting Question
Excel Lookup / Match across two worksheets and return red cells on both in one list
asked on
Hi Experts
Ive just received some excellent assistance on the attached workbook however there is one more (final) item Im struggling with
On the first tab - Completed - to the right is a section saying Total of Red on Both
Is there a way to look across two worksheets - Results Units and Results Costs - and if a red cell appears on both, to list this on the front sheet under the above title - or set it up on both so I can drag the results onto the Completed tab?
If it did not involve conditional formatting and colour I dont believe I would have an issue however Im not sure if its possible to include the colour variable into the lookup / syntax?
Any suggestions would be welcome
J
Copy-of-Cycle-count-pick-face-map-2.xlsm
Ive just received some excellent assistance on the attached workbook however there is one more (final) item Im struggling with
On the first tab - Completed - to the right is a section saying Total of Red on Both
Is there a way to look across two worksheets - Results Units and Results Costs - and if a red cell appears on both, to list this on the front sheet under the above title - or set it up on both so I can drag the results onto the Completed tab?
If it did not involve conditional formatting and colour I dont believe I would have an issue however Im not sure if its possible to include the colour variable into the lookup / syntax?
Any suggestions would be welcome
J
Copy-of-Cycle-count-pick-face-map-2.xlsm
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 12 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.