The image linked below probably explains best. In short, I want to assign an item from column 1 (which is a data validation list sourced from column 1, in column 4) to a purchase price that I enter. That’s already good.
What I’m looking for is for that purchase price to appear in column 3 beside the correct item chosen from the data validation list. Then I can compare the difference between the budget and actual purchase amount.
Much appreciated, thank you!