Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup?
I am trying to create a sheet that will list what other sheets some of our
associates are on. Right now I am trying to use a VLOOKUP for this, but all values next to the names remain 0. For example: Joe Schmoe works on lines A, C, & F. Each line has its own excel sheet. Is there any way to search all the sheets for his name and have them listed? I thought Vlookup would work. Any ideas? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup?
For better answers, expand on your query. Provide detail, specifics. Always
post your formula(s) attempted/used and sample data, sheetnames, required logics/intents, results etc. Good luck! -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "collyer3" wrote in message ... I am trying to create a sheet that will list what other sheets some of our associates are on. Right now I am trying to use a VLOOKUP for this, but all values next to the names remain 0. For example: Joe Schmoe works on lines A, C, & F. Each line has its own excel sheet. Is there any way to search all the sheets for his name and have them listed? I thought Vlookup would work. Any ideas? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup?
"Max" wrote: For better answers, expand on your query. Provide detail, specifics. Always post your formula(s) attempted/used and sample data, sheetnames, required logics/intents, results etc. Good luck! -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "collyer3" wrote in message ... I am trying to create a sheet that will list what other sheets some of our associates are on. Right now I am trying to use a VLOOKUP for this, but all values next to the names remain 0. For example: Joe Schmoe works on lines A, C, & F. Each line has its own excel sheet. Is there any way to search all the sheets for his name and have them listed? I thought Vlookup would work. Any ideas? Thank you. Here's the formula I have been trying to use: =VLOOKUP(A4,'[Electronic matrix blank.xls]Matrix sheet'!$A$9:AA$420,5) For some reason, all names I am looking for pull up 0, whether the name is on the other sheet or not. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup?
=VLOOKUP(A4,'[Electronic matrix blank.xls]Matrix sheet'!$A$9:AA$420,5)
If you're looking up/matching text, always set the vlookup for an exact match, ie with the 4th parameter FALSE or zero. As-is, your expression omits the 4th param (ie its set to TRUE or 1) which requires that the lookup's 1st col A be sorted in ascending order (It's probably not sorted now?). Also, any extra white spaces present may be throwing apparently obvious matches off. Try it like this, with the 4th param set to zero (exact match), and with TRIM around the lookup value in A4: =VLOOKUP(TRIM(A4),'[Electronic matrix blank.xls]Matrix sheet'!$A$9:AA$420,5,0) You might also need to do a one-time clean up using TRIM on Matrix sheet's A9:A420 -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "collyer3" wrote: Thank you. Here's the formula I have been trying to use: =VLOOKUP(A4,'[Electronic matrix blank.xls]Matrix sheet'!$A$9:AA$420,5) For some reason, all names I am looking for pull up 0, whether the name is on the other sheet or not. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |