| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function needed to search and pull data from 1 table to another
Really need some help to determine what function/formula to use.
Table A contains names of Learners and their job functions. The same learner could be there twice, and some learners have no job funtion. Learner Name Job Function A, EASWAR Marketing A, EASWAR Marketing Aarts, Hans Abib, Marcelo Research Abib, Marcelo Research Abo El Azayem, Mohamed HR Abou-Taleb, Khaled Marketing Aceña Garcia, Luis Sales The second table just has learner names. I need to pull the job function from the other table to this. However, note that there could be someone on this list that is not in the list above, or again, in here twice. Learner Name A, EASWAR A, EASWAR Art Jones Abib, Marcelo Abib, Marcelo Abo El Azayem, Mohamed Abou-Taleb, Khaled Cat Smith |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function needed to search and pull data from 1 table to another
Hi,
assuming that your first list is in sheet2 column A and B and you want to pull the information in sheet1 where you have the names in column A starting row 2 in B2 enter =index(sheet2!$B$1:$B$1000,match(A1,sheet2!$A$1:$A $1000,0)) "Heidi" wrote: Really need some help to determine what function/formula to use. Table A contains names of Learners and their job functions. The same learner could be there twice, and some learners have no job funtion. Learner Name Job Function A, EASWAR Marketing A, EASWAR Marketing Aarts, Hans Abib, Marcelo Research Abib, Marcelo Research Abo El Azayem, Mohamed HR Abou-Taleb, Khaled Marketing Aceña Garcia, Luis Sales The second table just has learner names. I need to pull the job function from the other table to this. However, note that there could be someone on this list that is not in the list above, or again, in here twice. Learner Name A, EASWAR A, EASWAR Art Jones Abib, Marcelo Abib, Marcelo Abo El Azayem, Mohamed Abou-Taleb, Khaled Cat Smith |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function needed to search and pull data from 1 table to anothe
Hi Eduardo,
When use this it seems to just return the same list in the same order back on sheet one. For example, "Cat Smith" is on sheet 1, but not on sheet 2, using the formula, her job function comes back as "marketing", yet it shoul really have N/A. "Eduardo" wrote: Hi, assuming that your first list is in sheet2 column A and B and you want to pull the information in sheet1 where you have the names in column A starting row 2 in B2 enter =index(sheet2!$B$1:$B$1000,match(A1,sheet2!$A$1:$A $1000,0)) "Heidi" wrote: Really need some help to determine what function/formula to use. Table A contains names of Learners and their job functions. The same learner could be there twice, and some learners have no job funtion. Learner Name Job Function A, EASWAR Marketing A, EASWAR Marketing Aarts, Hans Abib, Marcelo Research Abib, Marcelo Research Abo El Azayem, Mohamed HR Abou-Taleb, Khaled Marketing Aceña Garcia, Luis Sales The second table just has learner names. I need to pull the job function from the other table to this. However, note that there could be someone on this list that is not in the list above, or again, in here twice. Learner Name A, EASWAR A, EASWAR Art Jones Abib, Marcelo Abib, Marcelo Abo El Azayem, Mohamed Abou-Taleb, Khaled Cat Smith |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function needed to search and pull data from 1 table to anothe
Hi,
I think we mixed up sheet names, I consider the first table is in sheet 2 and you want to pull the information in sheet 1 from sheet 2, I think your case is the other way use =index(sheet1!$B$1:$B$1000,match(A1,sheet1!$A$1:$A $1000,0)) =index(column to pull information from,match(cell you want to look into the table,range in the table where you have the names) "Heidi" wrote: Hi Eduardo, When use this it seems to just return the same list in the same order back on sheet one. For example, "Cat Smith" is on sheet 1, but not on sheet 2, using the formula, her job function comes back as "marketing", yet it shoul really have N/A. "Eduardo" wrote: Hi, assuming that your first list is in sheet2 column A and B and you want to pull the information in sheet1 where you have the names in column A starting row 2 in B2 enter =index(sheet2!$B$1:$B$1000,match(A1,sheet2!$A$1:$A $1000,0)) "Heidi" wrote: Really need some help to determine what function/formula to use. Table A contains names of Learners and their job functions. The same learner could be there twice, and some learners have no job funtion. Learner Name Job Function A, EASWAR Marketing A, EASWAR Marketing Aarts, Hans Abib, Marcelo Research Abib, Marcelo Research Abo El Azayem, Mohamed HR Abou-Taleb, Khaled Marketing Aceña Garcia, Luis Sales The second table just has learner names. I need to pull the job function from the other table to this. However, note that there could be someone on this list that is not in the list above, or again, in here twice. Learner Name A, EASWAR A, EASWAR Art Jones Abib, Marcelo Abib, Marcelo Abo El Azayem, Mohamed Abou-Taleb, Khaled Cat Smith |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function needed to search and pull data from 1 table to anothe
Hi,
Still returns data for "Cat Smith". Below is what is in Sheet 1, I input the formula to cell B2 on sheet 1 and copied contents down. Learner Name Job Function A, EASWAR Marketing A, EASWAR Marketing Art Jones 0 Abib, Marcelo Research Abib, Marcelo Research Abo El Azayem, Mohamed HR Abou-Taleb, Khaled Marketing Cat Smith Sales Here is what is in sheet 2 - seems to be picking up job function for Aceña Garcia, Luis with is "Sales" and putting it in for Cat SMith. Learner Name Job Function A, EASWAR Marketing A, EASWAR Marketing Aarts, Hans Abib, Marcelo Research Abib, Marcelo Research Abo El Azayem, Mohamed HR Abou-Taleb, Khaled Marketing Aceña Garcia, Luis Sales "Eduardo" wrote: Hi, I think we mixed up sheet names, I consider the first table is in sheet 2 and you want to pull the information in sheet 1 from sheet 2, I think your case is the other way use =index(sheet1!$B$1:$B$1000,match(A1,sheet1!$A$1:$A $1000,0)) =index(column to pull information from,match(cell you want to look into the table,range in the table where you have the names) "Heidi" wrote: Hi Eduardo, When use this it seems to just return the same list in the same order back on sheet one. For example, "Cat Smith" is on sheet 1, but not on sheet 2, using the formula, her job function comes back as "marketing", yet it shoul really have N/A. "Eduardo" wrote: Hi, assuming that your first list is in sheet2 column A and B and you want to pull the information in sheet1 where you have the names in column A starting row 2 in B2 enter =index(sheet2!$B$1:$B$1000,match(A1,sheet2!$A$1:$A $1000,0)) "Heidi" wrote: Really need some help to determine what function/formula to use. Table A contains names of Learners and their job functions. The same learner could be there twice, and some learners have no job funtion. Learner Name Job Function A, EASWAR Marketing A, EASWAR Marketing Aarts, Hans Abib, Marcelo Research Abib, Marcelo Research Abo El Azayem, Mohamed HR Abou-Taleb, Khaled Marketing Aceña Garcia, Luis Sales The second table just has learner names. I need to pull the job function from the other table to this. However, note that there could be someone on this list that is not in the list above, or again, in here twice. Learner Name A, EASWAR A, EASWAR Art Jones Abib, Marcelo Abib, Marcelo Abo El Azayem, Mohamed Abou-Taleb, Khaled Cat Smith |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| what is the best way to pull in external data from SQL table | Excel Discussion (Misc queries) | |||
| Macro needed to pull data from one worksheet and enter it in anoth | Excel Discussion (Misc queries) | |||
| Search function needed (sumproduct?) | Excel Worksheet Functions | |||
| Pull Pivot Table Data | Excel Discussion (Misc queries) | |||
| Pull pivot table data | Excel Discussion (Misc queries) | |||
Linear Mode
