?
Solved

Match & Calculation

Posted on 2014-07-28
5
Medium Priority
?
132 Views
Last Modified: 2014-07-28
Hi,

I have a spreadsheet with a cell highlighted yellow, i want a user to be able to add a target for a new team member, while reducing anothers target, the cell result wants to highlight the reduced members new target, so im thinking a match lookup and subtraction

I have manually typed in the result, im looking for some formula to update automatically,

Please find ss attached

Thanks
Mock-Up-Leavers---Joiners-EE.xlsx
0
Comment
Question by:Seamus2626
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 12

Expert Comment

by:James Elliott
ID: 40223874
how is the 10 calculated?
0
 
LVL 33

Expert Comment

by:Rob Henson
ID: 40223879
Even looking at the attached, it is not clear what you are trying to do.

What input is required?
What should change as a result of the input?

Thanks
Rob H
0
 

Author Comment

by:Seamus2626
ID: 40223930
The 10 is  calculated by

Cell H2 IN TAB Raw Data - D13 in tab Screen

So, im matching the name of the person from the tab screen with the name in tab raw data and then calculating the new target

Thanks
0
 
LVL 12

Accepted Solution

by:
James Elliott earned 2000 total points
ID: 40223942
=VLOOKUP(E13,'Raw Data'!$A$2:$H$4,8,FALSE)-Screen!D13
0
 

Author Closing Comment

by:Seamus2626
ID: 40224074
Monday, sorry for making an simple solution appear complicated

Thanks!
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question