jstewart1957
New Member
- Joined
- Jun 24, 2020
- Messages
- 3
- Office Version
- 365
- Platform
- MacOS
We have a template to track inventory with products we buy and they have associated costs. I've created a table on a separate tab in the file with a list of products in one column and the associated cost in the adjacent column. On the main inventory sheet, I would like to be able to enter the product name and have the cost column populated with the cost from the table on the separate tab. The list of products is rather lengthy, so using IF statements would be awkward. What function/formula would work?
Thanks in advance,
Jimmy
Thanks in advance,
Jimmy