M
michaelberrier
Title is kind of confusing, but basically it is this....
In cells A1:A4, there is a list of names, let say sports teams. In
cells B1:B4 are their rankings, obviously 1-4. Now, in cells C1 & C2
respectively, I want the names of the two teams that finish 1 & 2. I
thought about an =IF, but seems like that formula would have to be a
mile long to include all four teams and the possibility that they would
be ranked 1st or 2nd.
So I guess it would be something like "If B1:B4 =1, then the value of
whatever cell is next adjacent to that number.
Thanks.
In cells A1:A4, there is a list of names, let say sports teams. In
cells B1:B4 are their rankings, obviously 1-4. Now, in cells C1 & C2
respectively, I want the names of the two teams that finish 1 & 2. I
thought about an =IF, but seems like that formula would have to be a
mile long to include all four teams and the possibility that they would
be ranked 1st or 2nd.
So I guess it would be something like "If B1:B4 =1, then the value of
whatever cell is next adjacent to that number.
Thanks.