Vlookup?

  • Thread starter Thread starter collyer3
  • Start date Start date
C

collyer3

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?
 
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
 
Max said:
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
---



Thank you. Here's the formula I have been trying to use:
Click to expand...
=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.
 
=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
 
Back
Top