LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 361
Default LookUp/Match

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 trying to find a formula for row 2 in the table below that results like
this:

Date AA BAC DELL
20071217 0.76% NotFound 0.80%


Thank You in Advance


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Match and Lookup Biocellguy Excel Worksheet Functions 1 July 6th 07 01:48 AM
using MATCH, and LOOKUP harvey1649 Excel Worksheet Functions 9 May 7th 07 07:05 AM
Match or Lookup JULZ Excel Discussion (Misc queries) 2 August 28th 06 10:45 PM
Lookup? Match? pulling rows from one spreadsheet to match a text f cjax Excel Worksheet Functions 3 July 21st 06 02:51 PM
Lookup or Match ? carl Excel Worksheet Functions 4 July 12th 05 07:22 PM


All times are GMT +1. The time now is 05:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"