mediumCIMB · lookup
Find a branch code by city — a leftward lookup
Column A holds CIMB branch codes, column B the city each branch is in, column C the branch manager. E1 holds a city name. Write a formula in F1 that returns the branch code for that city — a column to the *left* of the one you're searching.
Starting grid
A1
Scroll to see all 6 columns →
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | BR-101 | Kuala Lumpur | Aiman | Johor Bahru | ||
| 2 | BR-102 | Johor Bahru | Bella | |||
| 3 | BR-103 | Penang | Chong | |||
| 4 | BR-104 | Ipoh | Dinesh |
Show expected output▾
Stuck? Ask the coach for a nudge that won't give the answer away, or reveal the reference solution and a short walkthrough of why it works.
F1
Scroll to see all 6 columns →
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | BR-101 | Kuala Lumpur | Aiman | Johor Bahru | ||
| 2 | BR-102 | Johor Bahru | Bella | |||
| 3 | BR-103 | Penang | Chong | |||
| 4 | BR-104 | Ipoh | Dinesh |