Method to grabbing specific cell?

Question

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

Capture.PNG

derm · Answer

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

Capture.PNG

Felipe_Ribeir0 · Answer

Hi @derm

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

derm · Answer

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.