Method to grabbing specific cell?

[derm]

Hi,

I'm attempting to create a formula where if the date is equal to one of the columns and the commodity is equal to one of the rows, then it would grab the value that was in that row and column. This would essentially be a V Lookup. Is it possible?

Best,

derm

[Felipe_Ribeir0]

Hi @derm 

Two ways of doing this:

[derm]

Hi, 

Thanks! I should've clarified a bit more. I meant in the use of a formula. But to explain in depth, I want to put the table I attached with another file. That file has a number of records that could vary in Date and Commodity. Depending on the record, I want to create a formula that grabs the corresponding numeric value and uses it within the aforementioned formula. This is very complex for me because I dont know how to do that dynamic select.

[Felipe_Ribeir0]

Hi @derm 

If you could provide both inputs and the expected output, it would help a lot.

[derm]

Hi Felipe, sorry for the late response.

I created some sample data to show you what I mean. Is it possible to use a formula that uses the condtions [commodity]=[c type] and [StartDate]=[month] to specifically grab the closing price that corresponds? I think creating a formula with a new column would help and thus allow for me to do what I need.

This is what I'm attempting.

Thanks, Derm