I'm looking for a tutorial on how to reference a table in another sheet using Excel 2003.
I have a table of Fuel data in two columns:
100,3240
200,5500
300,8760
etc.
etc.
On my main sheet, I want to enter in a fuel weight such as 200, and then have Excel auto-populate the cell next to it with '5500' from the table.
How can I do this? Is there a tutorial that I can read?
Thank you...
Bookmarks