using data from another cell

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?
 
D

Doug

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
Excel does not accept text format! 0
Drop down list control value in vba 2
Cell data entering slow! 0
Excel - Wich Function should I use? 1
VBA Coding Help for Beginner 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
Need Help with a VBA subroutine 0

Top