Your Column O -- In what Sheet and Workbook is it in?


"Tester" wrote in message
:

Hi. Spreadsheet A in Workbook 2 has various columns which match the cell
values in Spreadsheet H of Workbook 1.
Column O is a control list of Suppliers names so spelling etc is exact
throughout.
On Spreadsheet A in Workbook 2 I have inserted a column C to check the value
of Column I against Column O. If it finds a match in the list, I want it to
show the name but if not, I want it to remain blank.

Could someone help with this formula please?
TIA
Chris