CODEWITHSUNDEEP
excel
eski
eski

Reputation: 507

Simple tournament bracket system

I'm making a simple tournament bracket system..

So basically I have table A, in it are two values. I have a cell where one of the value is defined.

I need to look up that value in table A and copy the OTHER value to a new cell..???

So table has value "Hello" and "World". In the lookup cell i have the word "Hello". Now I need the new cell to be "World".

Upvotes: 0

Views: 329

Answers (1)

Boris Stitnicky
Boris Stitnicky

Reputation: 12588

Given a table 2 x 4 in the cells A1:B4, where one of the pairs is "Hello" and "World", the following function will fetch you "World":

=VLOOKUP("Hello", A1:B4, 2)

Upvotes: 0

Related Questions