Lookup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi I would like to lookup the values in column C and if it has a match in column A then if it does I want to be able to put a T in Column D against the Parents row. Column C is the Parent of some of Column A but not all Column A has children. Column A also has the parents names. Sorry if this doesn't make sense please email. Basically what I am trying to do is to be able to report on Parents by cretaing a new column with a value in it so iI can sort by it.

Appreciate your help


AAMAN_LU62 Amante Superannuation Fund, A
AB&CA_LUGD Dunigan T/A Kelshah Melaleuca Gardens, AB & CA
AB&CA_LUGE Dunigan t/a Dunigans Tea Trees, AB & CA & GJ & PL
ABBEY_LVCK Abbey, Darren Graham
ABBEY_LVCL Abbey, Fiona
ABLE__LVCM Able, Trevor Edward
ADAMS_LVCP Adams, Robert Edwin
ADAMS_LVCQ Adams-Ross, Eliza Jane
ADIL__LU59 Adil, Ylver George GEORO_LU5G
ADIL__LU5A Adil, Rhonda Mary GEORO_LU5G
ADIL__LU5B Adil, Jason Daniel
ADIL__LU5C Adil, Julie Renee JULIE_LU5F
AFICH_LUIB Fichera Family Trust, A
AHGUM_LVCR Ah Gum, Graham John
AHLER_LU5H Ahlers, Stephen George SG&SA_LU5J
AHLER_LU5I Ahlers, Sue Anne SG&SA_LU5J
GEORO_LU5G Georonda Trust
JULIE_LU5F Terzi & Adil, Nello & Julie
SG&SA_LU5J Ahlers, SG & SA
 
Try something like:

In D2 :=IF(TRIM(C2)=TRIM(A2),"T","-")

Campbell said:
Hi I would like to lookup the values in column C and if it has a match in
Click to expand...
column A then if it does I want to be able to put a T in Column D against
the Parents row. Column C is the Parent of some of Column A but not all
Column A has children. Column A also has the parents names. Sorry if this
doesn't make sense please email. Basically what I am trying to do is to be
able to report on Parents by cretaing a new column with a value in it so iI
can sort by it.
 
Hi


D2=IF(ISERROR(VLOOKUP(C2,A$2:A$1000,1,FALSE)),"","T")


Arvi Laanemets


Campbell said:
Hi I would like to lookup the values in column C and if it has a match in
Click to expand...
column A then if it does I want to be able to put a T in Column D against
the Parents row. Column C is the Parent of some of Column A but not all
Column A has children. Column A also has the parents names. Sorry if this
doesn't make sense please email. Basically what I am trying to do is to be
able to report on Parents by cretaing a new column with a value in it so iI
can sort by it.
 
Back
Top