Hi All,
I have a data set where I need to find a specific number within an array and then find the corresponding name. I've inserted the table below. I'm looking to figure out who's weight is 5.8 and have that name get pulled from the "All Weights" table to the "Top Weights" table. The "All Weights" table will be updating all the time so it needs to be able to react to those changes as it goes. Also, if there is a tie for weight, I need to find a way to pull both names into different cells. I've tried a series of iferror vlookups, match formulas, I just can't figure it out. I don't know if I've explained this clearly but hopefully you can help.
Thanks!
Adam
<tbody>
</tbody>
I have a data set where I need to find a specific number within an array and then find the corresponding name. I've inserted the table below. I'm looking to figure out who's weight is 5.8 and have that name get pulled from the "All Weights" table to the "Top Weights" table. The "All Weights" table will be updating all the time so it needs to be able to react to those changes as it goes. Also, if there is a tie for weight, I need to find a way to pull both names into different cells. I've tried a series of iferror vlookups, match formulas, I just can't figure it out. I don't know if I've explained this clearly but hopefully you can help.
Thanks!
Adam
Top Weights | |||||
Name | Weight | ||||
#1 | TBD | 5.8 | |||
#2 | TBD | 5.2 | |||
#3 | TBD | 5.2 | |||
All Weights | |||||
Name | Weight 1 | Weight 2 | Weight 3 | Weight 4 | Weight 5 |
Adam | 1 | 2 | 3 | 4 | 5.2 |
Mike | 0.5 | 1.5 | 2.5 | 3.5 | 4.5 |
John | 1.2 | 2.2 | 3.2 | 4.2 | 5.2 |
Larry | 0.8 | 1.8 | 2.8 | 3.8 | 4.8 |
Chriss | 1.8 | 2.8 | 3.8 | 4.8 | 5.8 |
<tbody>
</tbody>