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

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

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

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

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

Try an exact match then

=IF(ISNA(INDEX($O$2:$O$50,MATCH(I2,$O$2:$O$50,0),1 0)),"",(INDEX($O$2:$O$50,M
ATCH(I2,$O$2:$O$50,0),0)))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Tester" wrote in message
...
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,MA
TCH(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

I understood that you wanted in Col C the Content of Col I only if It
(the content of Col I) could be matched with the content of Col O.
Sorry,


"Tester" wrote in message
:

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