LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
carl
 
Posts: n/a
Default Match or Index Question

My data table is set-up like this:

DataTable Raw Adjusted Special Total
BOX050 90 96.67 0 96.67
BOX060 167 179.01 0 179.01
BOX234 0 0 0 0
BOX355 104 115.34 0 115.34
BOX549 156 166.01 2 168.01

I am trying to create a table like this and think it is possible with index
and match functions:

New Table Raw Adjusted Special Total
BOX050 90 96.67 0 96.67
BOX355 104 115.34 0 115.34
BOX549 156 166.01 2 168.01
BOX898 No Match No Match No Match No Match


Is it possible ?

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 + Index(?) Question KemS Excel Discussion (Misc queries) 2 March 31st 05 01:23 AM
Match, Index, Vlookup, Large....Help Please [email protected] Excel Worksheet Functions 3 December 15th 04 01:38 PM
Match & Index Phyllis B. Excel Worksheet Functions 2 November 27th 04 03:26 PM
Find a match that;s not exact Phyllis Excel Worksheet Functions 0 November 8th 04 08:12 PM
Vlookup, Index & Match Phyllis Excel Worksheet Functions 1 November 8th 04 06:11 PM


All times are GMT +1. The time now is 12:08 AM.

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"