I need to reformat raw data of over 45000 rows. It is basically a stock market data file. File attached FNO1.ods. I could attach only part of the file (some rows deleted) as file upload size is restricted.
I tried with VLOOKUP, but it is giving me just the first match for “SYMBOL” without an option to match the “EXPIRY_DATE” and “FUTSTK” columns. I don’t know how to accomplish that. For the table I am preparing I need “FUTSTK”, “SYMBOL” columns to match “EXPIRTY_DATE” value from among several other heads under these columns to choose from and output value has to be corresponding figure in the “CLOSE” column.
The table format I am trying is just beside the raw data (in the same sheet).
I hope somebody can help / guide me.
(Slightly edited by @Lupp to get the link in the right place.)