Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 361

LookUp and Match Question

My Data Table is Like this:

Date AA GOOG DELL
20071212 0.99% 3.89% 1.32%
20071213 0.48% 2.96% 0.46%
20071214 1.02% 2.25% 1.37%
20071217 0.76% 4.37% 0.80%
20071218 0.73% 5.00% 0.52%

I am trying to find a formula for B2:D2 below that will produce this
result..

Date GOOG DELL IBM
20071217 4.37% 0.80% NotFound

Thank YOu in Advance

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
LookUp/Match/INDEXing Question	carl	Excel Worksheet Functions	1	December 18th 07 06:41 PM
LookUp/Match Question	carl	Excel Worksheet Functions	2	December 14th 07 07:05 PM
Match Lookup question	chad	Excel Worksheet Functions	8	September 12th 06 12:45 AM
A question for Match and Lookup	Bin	Excel Discussion (Misc queries)	1	June 26th 06 07:45 PM
LookUp/Match Question	carl	Excel Worksheet Functions	2	October 5th 05 07:36 PM

All times are GMT +1. The time now is 03:24 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us