Search code examples
if-statementgoogle-sheetssumgoogle-sheets-formulagoogle-query-language

Assigning an number to beside a data validation source

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!

https://ibb.co/xSsSQ6X

Solution

  • delete everything in ranhe C4:C and use this in C4:

    =INDEX(IFNA(VLOOKUP(A4:A; D:E; 2; 0)))