How to locate a cell and return value of neighbour cell
Hi, I have a table containing data pairs in columns like [Title] [Value]. The table has multiple columns resulting in a table like this:
Title | Value | Title | Value | Title | Value |
---|---|---|---|---|---|
Apples | 100 | Bread | 120 | Pork | 90 |
Melons | 120 | Pancake | 150 | Beef | 160 |
Peaches | 110 | Pie | 55 | Fish | 100 |
... |
In a different table, I want to enter a title and get the value next to it returned. E.g. I enter "Pancake" in column A and get "150" in column B.
I tried using Lookup but it doesn't support multi-column searches so I would have to create IF-chains for the pairs of columns.
The best way I could think of is to locate the address of the title cell and use Offset. Does anyone know a solution for this?
MacBook, OS X Mountain Lion (10.8), 2 GHz Core 2 Duo 1TB + 256 GB SSD