T
Tester
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
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