If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
vlookup question
hi
say i have colA and colB. i m using vlookup (in other sheet) to lookup for values in colA and returning corresponding value in colB. problem arises when the more than 1 value in colB for same value in colA. How can i get all the values of colB in such cases. thanks |
#2
|
|||
|
|||
vlookup question
Hi
you'll need VBA for this. You may have a look at Alan Beban's Array functions (available at: http://home.pacbell.net/beban) They include the function VLOOKUPS. -- Regards Frank Kabel Frankfurt, Germany schrieb im Newsbeitrag ... hi say i have colA and colB. i m using vlookup (in other sheet) to lookup for values in colA and returning corresponding value in colB. problem arises when the more than 1 value in colB for same value in colA. How can i get all the values of colB in such cases. thanks |
#3
|
|||
|
|||
vlookup question
thanks
what does he means by this. "Incorporating the functions in a Personal.xls type file will make them readily available whenever you are running Excel." i downloaded the file. but it's a regular excel file. wht should i do with it. thanks -----Original Message----- Hi you'll need VBA for this. You may have a look at Alan Beban's Array functions (available at: http://home.pacbell.net/beban) They include the function VLOOKUPS. -- Regards Frank Kabel Frankfurt, Germany schrieb im Newsbeitrag ... hi say i have colA and colB. i m using vlookup (in other sheet) to lookup for values in colA and returning corresponding value in colB. problem arises when the more than 1 value in colB for same value in colA. How can i get all the values of colB in such cases. thanks . |
#4
|
|||
|
|||
vlookup question
Hio
you can either copy the macros to your existing workbook or copy them to your personal.xls file. See the following site for more details about macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm -- Regards Frank Kabel Frankfurt, Germany schrieb im Newsbeitrag ... thanks what does he means by this. "Incorporating the functions in a Personal.xls type file will make them readily available whenever you are running Excel." i downloaded the file. but it's a regular excel file. wht should i do with it. thanks -----Original Message----- Hi you'll need VBA for this. You may have a look at Alan Beban's Array functions (available at: http://home.pacbell.net/beban) They include the function VLOOKUPS. -- Regards Frank Kabel Frankfurt, Germany schrieb im Newsbeitrag ... hi say i have colA and colB. i m using vlookup (in other sheet) to lookup for values in colA and returning corresponding value in colB. problem arises when the more than 1 value in colB for same value in colA. How can i get all the values of colB in such cases. thanks . |
#5
|
|||
|
|||
vlookup question
Sorry, i might be acting dumb, but i m new to this. I suppose i go to Tools/Macro/Macros.. to view the macros. but i dont see any there??? Also, wht is this personal.xls file. does it already exists in the system or i make one. (as i said i m dumb in excel) thanks again. -----Original Message----- Hio you can either copy the macros to your existing workbook or copy them to your personal.xls file. See the following site for more details about macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm -- Regards Frank Kabel Frankfurt, Germany schrieb im Newsbeitrag ... thanks what does he means by this. "Incorporating the functions in a Personal.xls type file will make them readily available whenever you are running Excel." i downloaded the file. but it's a regular excel file. wht should i do with it. thanks -----Original Message----- Hi you'll need VBA for this. You may have a look at Alan Beban's Array functions (available at: http://home.pacbell.net/beban) They include the function VLOOKUPS. -- Regards Frank Kabel Frankfurt, Germany schrieb im Newsbeitrag ... hi say i have colA and colB. i m using vlookup (in other sheet) to lookup for values in colA and returning corresponding value in colB. problem arises when the more than 1 value in colB for same value in colA. How can i get all the values of colB in such cases. thanks . . |
#6
|
|||
|
|||
vlookup question
Hi
take a look at the link I provided - this should explain (most) questions :-) -- Regards Frank Kabel Frankfurt, Germany schrieb im Newsbeitrag ... Sorry, i might be acting dumb, but i m new to this. I suppose i go to Tools/Macro/Macros.. to view the macros. but i dont see any there??? Also, wht is this personal.xls file. does it already exists in the system or i make one. (as i said i m dumb in excel) thanks again. -----Original Message----- Hio you can either copy the macros to your existing workbook or copy them to your personal.xls file. See the following site for more details about macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm -- Regards Frank Kabel Frankfurt, Germany schrieb im Newsbeitrag ... thanks what does he means by this. "Incorporating the functions in a Personal.xls type file will make them readily available whenever you are running Excel." i downloaded the file. but it's a regular excel file. wht should i do with it. thanks -----Original Message----- Hi you'll need VBA for this. You may have a look at Alan Beban's Array functions (available at: http://home.pacbell.net/beban) They include the function VLOOKUPS. -- Regards Frank Kabel Frankfurt, Germany schrieb im Newsbeitrag ... hi say i have colA and colB. i m using vlookup (in other sheet) to lookup for values in colA and returning corresponding value in colB. problem arises when the more than 1 value in colB for same value in colA. How can i get all the values of colB in such cases. thanks . . |
Thread Tools | |
Display Modes | |
|
|