using data from another cell

  • Thread starter Thread starter leo
  • Start date Start date
L

leo

I would like to type a name in one cell(1) then check in list (different
column) if the same name is there, and if it is there get a value of another
cell locate in the same row where. Can some one help me?
 
Create your second list and use VLOOKUP as follows:

Name is typed in: A1
List of names and values in: C1:D10

=VLOOKUP(A1,$C$1:$D$10,2,FALSE)
 
Back
Top