Thread: Need a function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Need a function

It "can" be done......one way would be with a combination of VLOOKUP and
HLOOKUP formulas, or maybe one humongus VLOOKUP formula or with VBA code, but
more details would be needed to give you a specific answer......such as sheet
names and column letters. Also, dealing with "names" is tricky business
cause they are almost never put down the same way twice....what with
initials, periods, middle names, prefixis suffixs, etc etc......

hth
Vaya con Dios,
Chuck, CABGx3



"Alma Brumley" wrote:

Can anyone help me with this??? Is there a function that can identify if a
person (name) is found in one of 4 worksheets.
--
Alma Brumley