How to update real time in excel

Question

We were told to remake this excel file. The sheet should update the numerical information when a number is given above(like 152 on the image). We are supposed to fetch data and from a different work sheet and display the sum in the boxes. How can I do it?

Answer 1

You could treat this as a "Dashboard" or you can write Lookup formulas to display the data.

So on a second "data" worksheet in the workbook you would have the data 1 row for each district number.

Here are some articles on writing lookup formulas:

5 Excel lookup functions demystified + 4 Resources for you https://chandoo.org/wp/2014/03/13/cp002-vtalkup...

6 Tips for Writing Better VLOOKUPs https://chandoo.org/wp/2010/11/02/excel-vlookup...

Posted on November 2nd, 2010 in Learn Excel - 15 comments

Ok, you have learned how to write vlookup formulas. You have also seen some pretty interesting examples of it (1, 2).

But how do you write better VLOOKUP formulas? Here is a list of 6 tips that work wonders with VLOOKUP writing.

Check Multiple Criteria with Excel INDEX and MATCH July 12, 2012

The INDEX function can return a value from a range of cells, and the MATCH function can calculate a value’s position in a range of cells.

Dynamic Lookup http://www.myonlinetraininghub.com/excel-factor...

by Mynda Treacy on September 22, 2012

VLOOKUP is great for returning information from a database, but one of the limitations is that the return information is static.

What if the user wishes to look for certain data one day but different data another day? This would require either two different sets of VLOOKUP functions or the functions would need to be reprogrammed.

Get values from multiple columns with VLOOKUP? https://chandoo.org/wp/2010/11/08/vlookup-array...

VLOOKUP is great for extracting information from a huge data table based on what you are looking for. But what if you need to extract more than one column of information? For eg. Lets say you have salesperson’s name in left most column, and monthly sales figures in next columns, one for each month. Now, you want to find the total sales made by a given sales person.

VLOOKUP Multiple Columns https://www.myexcelonline.com/blog/vlookup-mult...

What does it do?

Searches for a value in the first column of a table array and returns the sum of values in the same row from other columns (to the right) in the table array.

INDEX & MATCH functions in Excel - a better alternative to VLOOKUP

This tutorial demonstrates the key strengths of Excel's INDEX / MATCH function that make it superior to VLOOKUP. You will find a number of formula examples that will help you easily cope with many complex tasks when VLOOKUP fails. The MATCH function determines the relative position of the lookup value in the specified range of cells. From there, the INDEX function takes that number, or numbers, and returns a value in the corresponding cell.

by Svetlana Cheusheva 2014 08 13

Answer 2

Hi Sabir, the reason that worksheet is not updating is there are no formula in the relevant cells to generate the missing data . . .

Did you download this sheet?

If so, whoever put the sheet up on the web pulled out a lot of the formula before uploading it

Or is this sheet a school / university project?

Answer 3

yes, this is a project.

Answer 4

what formulas do you suggest I use for this? I know look ups are helpful but how can I fetch a bunch of data(in different rows) and display it's sum using lookups?

Answer 5

Well, for example cell C4 should have the formula:

="School District #"&A1&" "&VLOOKUP(A1,'District Name and Number'!A6:B638,2)

Each of the cells in question will require a different formula . . .