vlook up where one column has a range of numbers
 

one spreadsheet has a column with a range of numbers - ie. 1 - 10
representing member cards printed for a particular club name. what I would
like to do is that if a number falls within that range, then a new column
will be populated with the name of the club within the range of numbers. how
do I do this?

vlook up where one column has a range of numbers
 

See this:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"travos" wrote in message
...
one spreadsheet has a column with a range of numbers - ie. 1 - 10
representing member cards printed for a particular club name. what I would
like to do is that if a number falls within that range, then a new column
will be populated with the name of the club within the range of numbers.
how
do I do this?