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?
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.Sign up to join this community
Try this solution:
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
"Foo" would be in column A, "Bar" would be column B.