After checking if a cell value exists in a column, I need to **get the value of the cell next to the matching cell**. For instance, I check if the value in `cell A1`

exists in `column B`

, and assuming it matches `B5`

, then I want the value in `cell C5`

.

To solve the first half of the problem, I did this...

```
=IF(ISERROR(MATCH(A1,B:B, 0)), "No Match", "Match")
```

...and it worked. Then, thanks to an earlier answer on SO, I was also able to obtain the row number of the matching cell:

```
=IF(ISERROR(MATCH(A1,B:B, 0)), "No Match", "Match on Row " & MATCH(A1,B:B, 0))
```

So naturally, to get the value of the next cell, I tried...

```
=IF(ISERROR(MATCH(A1,B:B, 0)), "No Match", C&MATCH(A1,B:B, 0))
```

...and it doesn't work.

What am I missing? How do I append the column number to the row number returned to achieve the desired result?

Use a different function, like VLOOKUP:

```
=IF(ISERROR(MATCH(A1,B:B, 0)), "No Match", VLOOKUP(A1,B:C,2,FALSE))
```