4

In Excel or OpenOffice calc I have

| Foo | Bar |
+-----+-----+
| A   | 1   |
| B   | 2   |

Is it possible to use VLOOKUP to search a value in the Bar column and return the value in the Foo column?

2

1 Answer 1

12

Try this solution:

=INDEX(A:B,MATCH(2,B:B,0),1)

This chooses a specific cell out of a matrix.

MATCH retrieves the row inside the matrix B:B where "2" was found with exact match (0).

INDEX uses this row, and a given column (1), to refer to a specific cell inside a matrix A:B.

"Foo" would be in column A, "Bar" would be column B.

1
  • +1 Also working in Google Sheets. Dec 20, 2021 at 13:24

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .