Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Is there any reason why you can't just sort your list?
Insert a "helper" column and extract the 3 digits: =--RIGHT(A2,3) And copy down as needed. Then select the *entire* list, including the inserted "helper" column, and sort on the helper. You can then delete the "helper". -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "carl" wrote in message ... 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. |
#3
|
|||
|
|||
sort does not solve the problem. thank you anyways. need the formula to do
matching of the values. "RagDyer" wrote: Is there any reason why you can't just sort your list? Insert a "helper" column and extract the 3 digits: =--RIGHT(A2,3) And copy down as needed. Then select the *entire* list, including the inserted "helper" column, and sort on the helper. You can then delete the "helper". -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "carl" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |