I am looking to come up with a formula that will match two items on separate tabs and different lines and pull data from one tab to the other. The Item in Column A will not always be set on that line so the formula in Column B cannot be static to that line.(Example would be...whether or not ITEMXC is on line 9 or line 223, I need it to pull the QTY data from TAB2....) So basically I need a formula that I can just copy throughout column B to pull the matching data in TAB2. I have attached a simple version of what I am looking for with descriptions in bold and where I want the formula in Red Bold. I will be doing this across 20 tabs for about 2,000 different items so having the ability to automate everything to appear on one page on the same line will be wonderful. I don't even know if this is possible. Excel 2007
I currently use this formula to match items that will always be on the same line in TAB1...
=INDEX(TAB2!B:B,MATCH("ITEM3",TAB2!$A:$A,0)) This formula would be next to ITEM3 in column B on TAB1 but if I reload the data and ITEM1 moves from line 8 to line 16, I would have to copy and paste the formula down to line 16. I am working with 2,000 items that fluctuate where they are on the list so copy and pasting constantly each formula for each line is not worth the time.
Thanks for any input.
Bookmarks