I need some help figuring out some Google Sheets function. I'm trying to look for the value of an adjacent cell based on a key. The problem is that the table has several rows and columns to search for. For example:
| A | B | C | D | 1 | Alpha | 5 | Bravo | 10 | 2 | Charlie | 15 | Delta | 20 |
The list goes on for several more rows and columns. What I'm looking for for example, is when I use "Delta" as my search key, it will return the value 20 for me.