This formula does work but it is enormous:

`=IF(X3=B2,K2,IF(X3=B3,K3,IF(X3=B4,K4,IF(X3=B5,K5,IF(X3=B6,K6,IF(X3=B7,K7,IF(X3=B8,K8,IF(X3=B9,K9,IF(X3=B10,K10,IF(X3=B11,K11,IF(X3=B12,K12,IF(X3=B13,K13,IF(X3=B14,K14,IF(X3=B15,K15,IF(X3=B16,K16,IF(X3=B17,K17,IF(X3=B18,K18,IF(X3=B19,K19,IF(X3=B20,K20,IF(X3=B21,K21))))))))))))))))))))`

Here's what it's doing:

```
If X3 is the same as B2, show the contents of cell K2.
If X3 is the same as B3, show the contents of cell K3.
If X3 is the same as B4, show the contents of cell K4.
...etc etc etc all the way to...
If X3 is the same as B21, show the contents of cell K21.
```

Since B2:B21 is simply a column of cells and K2:K21 is also just a column of cells, is there any way to shorten the above formula, so it's not enormous?

I don't know how to turn this into 2 ranges of B cells and K cells.

Trying something like this doesn't work:
`=IF(X3=B2:B21,K2:K21)`

Because telling Excel to use `:`

is telling it to add together everything from B2 to B21 and K2 to K21. I wondered if there's some other separator (not a `:`

) that tells Excel to treat each cell individually as opposed to adding them up?

This doesn't work:
`=IF(X3=B2-B21,K2-K21)`

That results in: `#VALUE!`

The problem is, whichever number the B cell is also has to stay matched up with the corresponding number (horizontally) in the K cell.

Thanks in advance to anyone that might know the answer, that I am sure is really simple if the functionality exists in Excel.