CODEWITHSUNDEEP
excelexcel-formula
Eidrizi
Eidrizi

Reputation: 27

How to use vlookup to check the data i need and gives me the value

I have the dataset with values, i Need that vlookup function gives me a value based on criteria that i set. For example: i Need all the prognose values of the series Name NGA based on the Date production. I have constructed somehow the dataset so it could be more clear.

=VLOOKUP(F3&N$1;$A$2:$I$500;9;TRUE)

i want that in NGA column that are only the prognose of NGA inside based on the date column Dataset

The expected values to be in this way Expected values

Upvotes: 0

Views: 37

Answers (1)

JvdV
JvdV

Reputation: 75950

To me what you described and show through your sample data can be achieved through:

=IF($D2=K$1,$G2;"")

Upvotes: 0

Related Questions