Named Range and Lookup

[ML]

Hello
In a sheet called Birthdays, I have a Range of cells, A2:C25 which has a
list of all my kids, nephews & neices in one column, their birth dates in
another and their ages in the 3rd. I've called this Kids.
In another sheet I've got a kind of journal of dates of events and stuff
the family have done etc. I want to put along the age of the kid they each
refer to but without having to keep trying to figure it out as there are a
lot of kids.
With the Insert Functions wizard , I've created a lookup formula that goes
=VLOOKUP(Q11,Birthdays!$A$2:$C$25,3)
except some birthdays are wrong.

Also my main question is: how do I use the 'Kids' table without having to
choose the range Birthdays!$A$2:$C$25,3

I've used something like that before but I'm getting confused with where the
colons and commas go. I think.
J

 

[Eugene]

ML,
Type it as a word as below:
=vlookup(Q11,Kids,3, false)

Note: I suggest you put "false" after the index option so it would look for
the EXACT match of the value you're looking for. This will also eliminate the
possibilities of incorrect values, but will return an #N/A if the value is
not available.

 

[Gord Dibben]

=VLOOKUP(Q11,Kids,3,FALSE)

The FALSE argument will return #N/A if no value matched to Q11


Gord Dibben MS Excel MVP