Do I use VLOOKUP???

  • Thread starter Thread starter michael
  • Start date Start date
M

michael

I am trying to use a function that will compare a cell to
a range of cells (column) and pull a coinciding value from
another range (column) Let me see if I can show:

A B C D
1 single 50
2 married 100
3 1 kid 150
4 2 kids 200

I want to be able to enter into column C: single, married,
1 kid, or 2 kids and then be able to pull the coinciding
value from column B and have it pop into column D

Obviously confused.
Thanks
 
Michael,

Yes a vlookup will do what your looking for.

=VLOOKUP(C1, A1:B4, 2, False)

Dan E
 
Back
Top