Importing data from a different workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

One workbook has a chart of temperatures and corresponding weights such as 40
= 1.0076. In another workbook I have a form where the temperature is placed.
I would like to have a cell in this workbook calculate the weight. An
example of what I need would be if cell u21 = 45 then cell u33 would use the
workbook containing the chart to place the corresponding weight.
 
Hi Mike,
I think you want to use VLOOKUP with a sorted list, since you will
not have an exact match on your argument.

If you are using a table, don't understand what you mean by
calculate.
 
You must log in or register to reply here.

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

Validation List 2
Standard Deviation from one sheet to another 1
The right formula is? 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Finding the weighted average of text that have been given values 1
Hyperlink to a specific worksheet in another workbook 5
Need help with Line Chart... 5
calculate shipping costs in excel 2007 2

Back
Top