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?
Try this solution:
This chooses a specific cell out of a matrix.
"Foo" would be in column A, "Bar" would be column B.