Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 71
  • Last Modified:

Need Help Converting an Excel formula to work on multi sheet

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
0
Matt Pinkston
Asked:
Matt Pinkston
  • 2
  • 2
1 Solution
 
QlemoC++ DeveloperCommented:
Change your reference accordingly. E.g. A of Scores is referred by  Scores!A. Because of the space in the other sheet name you will need to enclose the name in single quotes like in 'DHC Detail'!A.
0
 
Matt PinkstonAuthor Commented:
Yea I get that but only when DHC Detail Column A has a match on Scores column A
0
 
Matt PinkstonAuthor Commented:
So basically

If Scores A = DHC Detail A then

using the e* from Scores
=IF(E5="_IM1_/img/samples/flag_green.gif_IM2_Deal Status_IM3_",5,IF(E5="_IM1_/img/samples/flag_yellow.gif_IM2_Deal Status_IM3_",3,IF(E5="_IM1_/img/samples/flag_red.gif_IM2_Deal Status_IM3_",1,1)))  
 
and if no match column should be left blank
0
 
QlemoC++ DeveloperCommented:
Not getting you exactly. Are we on one of this two sheets with the formula?
I reckon "Scores A" means "Scores A on the same row as the formula"?
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now