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!
CodePudding user response：
delete everything in ranhe C4:C and use this in C4:
=INDEX(IFNA(VLOOKUP(A4:A; D:E; 2; 0)))