Here's a simple explanation of what I'm having trouble with.

Column A: List of 2300 order numbers

Column B: Email Address associated with an order number

Column C: List of 100 specific order numbers that I need the email address for

So, I'm looking to search column A for a value that matches C, and return the email address from column B in a new column (D).

The current formula almost works, but instead of returning the email address where A matched C, it returns the email address from the same row.

```
=IF(ISERROR(MATCH(C2,A:A,0)),B2)
```

Essentially I just need B2 in the formula above to return the value from the same line that matched.

## Best Answer

I think what you want is something like:

I should mention that MATCH checks the

positionat which the value can be found within A:A (given the`0`

, or FALSE, parameter, it looks only for an exact match and given its nature, only the first instance found) then INDEX returns the value at that position within B:B.