Help with Crazy Lookups

R

rkhuntjr

Hello folks.
I have a pretty tough Excel puzzle that I hope you guys can help m
decode. I created a Web query that downloads Yahoo Fianance's Analys
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 sound
easy, but there is a table very similar to my "Revenue Est" tabl
("Earnings Est") that is making it hard to do a lookup. Also, my quer
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 m
attachment to see exactly what I need. Please note the "web query" an
"ideal output" worksheets.

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

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with count/sumif 1
Help with Lookup 0
HELP with crazy formula 9
Lookups 8
LOOKUP function help 6
Filtered and Multiple Lookups 2
Table lookups with queries 8
Problem understanding dependant lookups 9

Top