Enjoy_Playing
New Member
- Joined
- Apr 21, 2002
- Messages
- 1
I tried the =MATCH(A10,$B$2:$B$6,FALSE)and the =INDEX($A$2:$A$6,MATCH(A10,$B$2:$B$6,FALSE),1) using your employee worksheet sample in the article, but the results showed "N/A" for both these statements. I've tried different values (A8 i/o A10), but I still get the same results.
I wanted to see if these functions would work for in getting data from different rows on Sheet1 (database) linked to Sheet2 (report), Sheet3 (report), Sheet4 (report), instead of having to copy/paste. So, if I have a "X" in column A1, a "Y" in column A2, and a "Z" in column A3, how do I tell excel to link all "X" rows in column A to Sheet2, all "Y" rows in column A to Sheet3 and all "Z" rows in column A to Sheet4? Will INDEX/MATCH work, or is there a better way to do this?
I sure would appreciate knowing why I couldn't get the above stated formulas to work, and if INDEX/MATCH is the solution for my linking data to different reports. Thank you in advance.
I wanted to see if these functions would work for in getting data from different rows on Sheet1 (database) linked to Sheet2 (report), Sheet3 (report), Sheet4 (report), instead of having to copy/paste. So, if I have a "X" in column A1, a "Y" in column A2, and a "Z" in column A3, how do I tell excel to link all "X" rows in column A to Sheet2, all "Y" rows in column A to Sheet3 and all "Z" rows in column A to Sheet4? Will INDEX/MATCH work, or is there a better way to do this?
I sure would appreciate knowing why I couldn't get the above stated formulas to work, and if INDEX/MATCH is the solution for my linking data to different reports. Thank you in advance.