I've found a things, but I can't piece this together. From tab 1, I need to find and item on tab 2, move 1 cell left, and up to the next cell with data.
First Tab: (the small blue info is what I want to pull from tab two)
<tbody>
</tbody>
Second tab:
<tbody>
</tbody>
I've got an index/indirect/match formula to work to pull specific info, which works very well. But trying to include an offset is proving to be a hurdle. Should I be looking at a lookup() formula?
First Tab: (the small blue info is what I want to pull from tab two)
Name | Number | Description | other |
77-dept | 11 | ....... | ....... |
77-dept | 12 | ....... | ....... |
77-dept | 13 | ....... | ....... |
88-name | 14 | ....... | ....... |
<tbody>
</tbody>
Second tab:
Name | Number | Descitp... |
77-Dept | ||
11 | ....... | |
12 | ....... | |
13 | ....... | |
88-name | ||
14 | ....... |
<tbody>
</tbody>
I've got an index/indirect/match formula to work to pull specific info, which works very well. But trying to include an offset is proving to be a hurdle. Should I be looking at a lookup() formula?