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

x
Solved

# Match & Calculation

Posted on 2014-07-28
Medium Priority
141 Views
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
Question by:Seamus2626
• 2
• 2

LVL 12

Expert Comment

ID: 40223874
how is the 10 calculated?
0

LVL 34

Expert Comment

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

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

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

Author Closing Comment

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

Thanks!
0

## Featured Post

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to usâ€¦
###### Suggested Courses
Course of the Month11 days, 2 hours left to enroll

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

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