Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Diffing two values

Status
Not open for further replies.

oomeheadhurts

Technical User
Jul 18, 2006
8
GB
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.
 
As you prefer NOT to use VBA you may get more accurate answers here:
forum68

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top