troubleshooting Question

Need Help Converting an Excel formula to work on multi sheet

Avatar of Matt Pinkston
Matt Pinkston asked on
Microsoft Excel
4 Comments1 Solution88 ViewsLast Modified:
I currently have the following formula (below) which works great but I now need to tweak it to work multi sheet.

=IF(P5="_IM1_/img/samples/flag_green.gif_IM2_Deal Status_IM3_",5,IF(P5="_IM1_/img/samples/flag_yellow.gif_IM2_Deal Status_IM3_",3,IF(P5="_IM1_/img/samples/flag_red.gif_IM2_Deal Status_IM3_",1,1)))

My workbook now has the following tabs

DHC Detal
Scores

before in column AB I had the formula above but now rather than look at the existing sheet line it needs to look at TAB Scores and when the value in DHC Detail column A has a match somewhere in Scores Column A then the formula would look at the value in Scores column E
ASKER CERTIFIED SOLUTION
Qlemo
"Batchelor", Developer and EE Topic Advisor

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Top Expert 2015

The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
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 4 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.

-Mike Kapnisakis, Warner Bros