Help with Crazy Lookups
 

Hello folks.
I have a pretty tough Excel puzzle that I hope you guys can help me
decode. I created a Web query that downloads Yahoo Fianance's Analyst
Estimates for any given stock.

I need it to extract most of the data from the "Revenue Est" table.
Sounds easy, but the location of the data might change after a refresh.
So it sounds like a I need to do some sort of lookup... Also sounds
easy, but there is a table very similar to my "Revenue Est" table
("Earnings Est") that is making it hard to do a lookup. Also, my query
automatically merges cells, so I'm a tad thrown off by that too.

It's kinda hard to explain, so it might be easiest to check out my
attachment to see exactly what I need. Please note the "web query" and
"ideal output" worksheets.

I am using Excel for Mac. I do not have the "New Web Query" option like
I do in my Windows verison, so I guess I'm stuck using a iqy file and
crazy lookups. I would greatly appreciate a push in the right direction
to figure out the crazy lookups.

Thank you guys so much for any help/advice.
Richard


+-------------------------------------------------------------------+
|Filename: help!.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5241 |
+-------------------------------------------------------------------+

--
rkhuntjr
------------------------------------------------------------------------
rkhuntjr's Profile: http://www.excelforum.com/member.php...o&userid=25577
View this thread: http://www.excelforum.com/showthread...hreadid=573342

Help with Crazy Lookups
 

See attached file.

HTH


+-------------------------------------------------------------------+
|Filename: Copy of help!.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5242 |
+-------------------------------------------------------------------+

--
Toppers
------------------------------------------------------------------------
Toppers's Profile: http://www.excelforum.com/member.php...o&userid=30076
View this thread: http://www.excelforum.com/showthread...hreadid=573342

Help with Crazy Lookups
 

Genius!

Thanks a lot.
Richard


--
rkhuntjr
------------------------------------------------------------------------
rkhuntjr's Profile: http://www.excelforum.com/member.php...o&userid=25577
View this thread: http://www.excelforum.com/showthread...hreadid=573342