How do I create a link between columns from a data chart?

S

Sara

I want to be able to set up a data chart within the excel spreadsheet that
when one cell is entered with an entry from the data chart, another cell will
automatically fill with the corresponding data from the chart. For example,
if I am making a mileage expense report, I want to be able to create the
chart with the towns and the specific miles it takes to drive there and when
I enter the town in the sheet, the mileage will automatically fill in. I
know that you have to create the data table with the information in a
separate location from the main information, but I forgot how to carryover
the information into the body of the report.
 
M

Miguel Zapico

Check the help for the VLOOKUP formula. It looks the most adecuate in this
case.

Hope this helps,
Miguel.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a chart from a table in word thats dynamic 0
Creating Network Diagram using a Chart SW integration 0
Doughnut Chart linked with the slicer in the pivot table 0
How to create a bubble chart with more than 2 variables. 0
Creating a Chart on form from selected data in query. 0
How to automate update on weekly reports spreadsheet 0
Transfer data between two tables 3
Auto Merge text from multiple sources 0

Top