Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Match + Index(?) Question | Excel Discussion (Misc queries) | |||
Match, Index, Vlookup, Large....Help Please | Excel Worksheet Functions | |||
Match & Index | Excel Worksheet Functions | |||
Find a match that;s not exact | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions |