shadow12345
Well-known Member
- Joined
- May 10, 2004
- Messages
- 1,238
I have spread sheet with a match that allows me to find row number of the item im looking for in another spread sheet.
My question can i use the row number to select information from the second spread sheet?
The information I want will always be 1 row down from the row number and two columns right.
Example
I have the result row 192
I want to target cell in the second sheet (called stats) b192 and take the information from D193.
Any ideas or suggestions?
My question can i use the row number to select information from the second spread sheet?
The information I want will always be 1 row down from the row number and two columns right.
Example
I have the result row 192
I want to target cell in the second sheet (called stats) b192 and take the information from D193.
Any ideas or suggestions?