Vlookup- 5 values to be displayed in another column as different T
 

Hi,
I have a column C100:C1001 where I want to find 5 values (which I have in a
separate help-like column) ACL, BB, CBI, GDDM, RDDM and then display them as
OPERATIONS.

I just can't get it right and this is URGENT as I am doing a report. Please
help.

Excel version 2002.
Thanks

Vlookup- 5 values to be displayed in another column as different T
 

Put in D100:
=IF(ISNUMBER(MATCH(C100,{"ACL";"BB";"CBI";"GDDM";" RDDM"},0)),"OPERATIONS","")
Copy down to D1001
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,700 Files:356 Subscribers:53
xdemechanik
---
"Piotr (Peter)" wrote:
Hi,
I have a column C100:C1001 where I want to find 5 values (which I have in a
separate help-like column) ACL, BB, CBI, GDDM, RDDM and then display them as
OPERATIONS.

I just can't get it right and this is URGENT as I am doing a report. Please
help.

Excel version 2002.
Thanks

Vlookup- 5 values to be displayed in another column as differe
 

Thank you so much. You have just saved my butt:))) I have an hour to go with
this report but I can proceed:)
Thx again

"Max" wrote:

Put in D100:
=IF(ISNUMBER(MATCH(C100,{"ACL";"BB";"CBI";"GDDM";" RDDM"},0)),"OPERATIONS","")
Copy down to D1001
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,700 Files:356 Subscribers:53
xdemechanik
---
"Piotr (Peter)" wrote:
Hi,
I have a column C100:C1001 where I want to find 5 values (which I have in a
separate help-like column) ACL, BB, CBI, GDDM, RDDM and then display them as
OPERATIONS.

I just can't get it right and this is URGENT as I am doing a report. Please
help.

Excel version 2002.
Thanks

Vlookup- 5 values to be displayed in another column as differe
 

Glad it helped ..
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 16,700, Files: 356, Subscribers: 53
xdemechanik
---
"Piotr (Peter)" wrote in message
...
Thank you so much. You have just saved my butt:)))
I have an hour to go with this report but I can proceed:)
Thx again