fatboy2131
New Member
- Joined
- May 5, 2008
- Messages
- 13
Hello Everyone,
Is there a formula in excel (2007) where I can return an entire row from one tab based off of the row being highlighted, or an indicator (like an "X" at then end of the row)?
For example, tab 1 (which is empty) looks like this:
_A..................B................C
Part #.......Description......Model
Then, Tab 2 - 50 looks like this:
__A................B.................C...........D
Part#........Description.......Model......RoHS?
1245............PCB................T...........X
4459............Nut................T
Each row that has the "X" in it is also highlighted blue.
Now, what I would like to do is have a formula or an easy way to populate Tab 1 with the information in Tab 2 - 50. So if the row has an "X" in the RoHS colum, then all the info from that row will be pulled into Tab 1. Hopefully that makes sense. Sorry for all the periods (.) but I couldn't get the format to line up in here...
If any of you have an idea or know if it is possible, please let me know.
Thanks!
Is there a formula in excel (2007) where I can return an entire row from one tab based off of the row being highlighted, or an indicator (like an "X" at then end of the row)?
For example, tab 1 (which is empty) looks like this:
_A..................B................C
Part #.......Description......Model
Then, Tab 2 - 50 looks like this:
__A................B.................C...........D
Part#........Description.......Model......RoHS?
1245............PCB................T...........X
4459............Nut................T
Each row that has the "X" in it is also highlighted blue.
Now, what I would like to do is have a formula or an easy way to populate Tab 1 with the information in Tab 2 - 50. So if the row has an "X" in the RoHS colum, then all the info from that row will be pulled into Tab 1. Hopefully that makes sense. Sorry for all the periods (.) but I couldn't get the format to line up in here...
If any of you have an idea or know if it is possible, please let me know.
Thanks!