Copy Data

[she00006]

I have a list in the OH HC tab in column A and would like to place their address in column B.
A list is found under tab OH Data where the addresses are found but I need to match the right Address from OH Data to Column B in OH HC.
I believe I would be using VLookup up but I don't know how to not add the address for those locations that do not match from both lists.

Thanks

[JBeaucaire]

In B3, then copied down, the formula would be:
=VLOOKUP(A3, 'OH Data'!$A:$B, 2, 0)

Since you're using Excel 2007+, you can wrap that in an IFERROR to make the nonmatches blank:
=IFERROR(VLOOKUP(A3, 'OH Data'!$A:$B, 2, 0), "")