I'm trying to write a function. My workbook has several sheets: one for each
month of any given year and then a summary sheet. In the summary sheet it
summarizes how much we were paid for certain items per Gton. I would like to
add a function in each month's sheet that will automatically put in the price
per gton for that item once I enter what the item is. For example, for
February were paid $1.00 for Item 1, $2.00 for Item 2, and $3.00 for Item 3
(this information will be entered on the summary sheet). As I type Item 1
into the Material column on February's sheet, I want $1.00 to automatically
be entered from the Summary sheet in the cost column of the sheet for
February. I don't even know what function to use nor do I know how I would
use the function if I knew which one to use.