Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Match help
Thanks Formula searches the way I need
But for some reason it is not Inputting the Correct Information into AG Cells =INDEX(Sheet1!$AG$1:$AG$8000,MATCH(1,($D$1:$D$8000 =Sheet1!D1)*($J$1:$J$8000**=Sheet1!J1),0)) With the data I have it will not be in the same order all the time and items and lines will be removed and added. I think this code is for if the line stay the same For example On Sheet 1 D= Account Number J= Product Code AG= Notes Sheet 2 is the same D= Account Number J= Product Code AG= Notes But the information inside the cells will mostly be different And in different order. What I needs that if Sheet1 (D & J) upto 8000 lines = (Sheet2 (D & J) upto 8000 lines then Sheet 2 (AG) = Sheet 1 (AG) Sorry hard to explain In a nut shell Sheet1 (D&J) LINE 5) Sheet2 (D&J) LINE 800) Both Match I have notes typed In AG(Sheet1) Now I need these notes to be shown in Sheet2(line 800) now? Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match Index | Excel Worksheet Functions | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Find a match that;s not exact | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions |