Forum Discussion
formula to auto entry an amount based on the kind
I am not sure the best way to describe what I am trying to do. I have different tables and I want to be able to enter a name then have it get a price from a different table and automatically an amoun...
You wrote: I am trying to enter an if formula but I can not figure out how to do the last part.
I'd recommend using the VLOOKUP function instead of IF. Here's a reference on how VLOOKUP works that should help. If it doesn't get you through to a solution, come back and post again.
https://exceljet.net/excel-functions/excel-vlookup-function
Thank you, I will try that.