| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup with Multiple like values in the reference column | Excel Worksheet Functions | |||
| adding up vlookup values in one column and in between them | Excel Discussion (Misc queries) | |||
| adding up vlookup values in one column and in between them | Excel Worksheet Functions | |||
| vlookup with all the same values in one column | Excel Discussion (Misc queries) | |||
| Pivot Table (vlookup 2 column text values, return 1 value) | Excel Discussion (Misc queries) | |||
![Piotr (Peter)[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
