Vlookp-matching names between sheets

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

I am new to vlookup. i have figured out the argument, but want to enter part
of a name or an incomplete name and have vlookup find the name in the other
sheet. i tried match but it finds the first similar one. i want to be able to
enter enough unique characters but not the whole name.

also, i want to be able to have vlookup seach sheets within a file. is this
possible?

Thanks!
 
I am new to vlookup. i have figured out the argument, but want to enter part
of a name or an incomplete name and have vlookup find the name in the other
sheet. i tried match but it finds the first similar one. i want to be able to
enter enough unique characters but not the whole name.

also, i want to be able to have vlookup seach sheets within a file.  isthis
possible?

Thanks!
Click to expand...

Karen, there's a discussion about using wildcards in vlookups. Hope
it helps.

http://groups.google.com/group/micr...nk=gst&q=wildcard+in+vlookup#6fa9a8ef698c66aa

Pierre
 
Pierre-
THat is awesome! It works like a champ. THanks much!

How about searching through an entire workbook and not the sheet?
 
Back
Top