Thanks for this, I've tried it but only get the content of the cell in
column I, regardless of whether it matches a value in the range O2:O50 or
not.
Chris
"JMay" wrote in message
...
There might be a better (and shorter) way, but in your cell C2 enter:

=IF(ISNA(INDEX($O$2:$O$50,MATCH(I2,$O$2:$O$50,0),1 )),"",(INDEX($O$2:$O$50,MATCH(I2,$O$2:$O$50,0),1)) )
<< All in one cell

And Copy down to C50;

HTH


"Tester" wrote in message
:

Oops sorry, Column O is in Spreadsheet A of Workbook 2
so i want something like this
If cell value in column I equals any one cell in column range O2:O50 then
show cell value in column I, otherwise leave blank
I have sorted the range alphabetically if that helps
Thanks for looking
Chris

"JMay" wrote in message
...
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