View Single Post
  #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.