oomeheadhurts
Technical User
Hi! I was trying to achieve a lookup with built in functions but getting nowhere.
Basically I have a table similar to the following
AOL BUY 25.12
NOK BUY 33.67
CSC BUY 121.56
AOL SELL 27.39
CSC SELL 115.84
BAA BUY 65.52
NOK SELL 34.32
BAA SELL 65.52
The table is raw data and does not come formatted, and I want to avoind preformatting it manually. As you can see, the data is not sorted. What I want to do is for each row, on the 4th colum, have it automatically get the stock name (e.g. AOL) and look up the corresponding BUY and SELL prices and give me the diff. This is a small example. the raw data could have hundreds of such entries.
Can I do this using in built functions or would I have to have a UDF or a macro. Please help.
Basically I have a table similar to the following
AOL BUY 25.12
NOK BUY 33.67
CSC BUY 121.56
AOL SELL 27.39
CSC SELL 115.84
BAA BUY 65.52
NOK SELL 34.32
BAA SELL 65.52
The table is raw data and does not come formatted, and I want to avoind preformatting it manually. As you can see, the data is not sorted. What I want to do is for each row, on the 4th colum, have it automatically get the stock name (e.g. AOL) and look up the corresponding BUY and SELL prices and give me the diff. This is a small example. the raw data could have hundreds of such entries.
Can I do this using in built functions or would I have to have a UDF or a macro. Please help.