vlookup help

[agron1974]

Hi there,

I'm trying to downsize my comics collection and downloaded the info into excel. In order to sell on eBay, i need to list the comic in a specific category. How do I setup a vlookup formula based of the year the comic was published. Below is the table I will be using for the formula.

	Category	year start	year end
Golden Age	1	1938	1955
Silver Age	2	1956	1969
Bronze Age	3	1970	1983
Copper Age	4	1984	1991
Modern Age	5	1992

<colgroup><col width="87"><col width="66"><col width="66"><col width="66"></colgroup> <tbody>
</tbody>

 

[Joe4]

Welcome to the Board!

Set up a lookup range where your two year fields are actually on the left (the first column needs to be "year start").
Then highlight all table (all four columns and the rows of data) and name the range like this: http://www.contextures.com/xlNames01.html

Then, you can use a VLOOKUP formula to return either the Category name or Category number (whichever you want).
Here is help on how VLOOKUP works: https://www.techonthenet.com/excel/formulas/vlookup.php

So, let's say that we named our range "Comics" and that you were looking up a value found in cell J1.
Then our formula might look like:
=VLOOKUP(J1,Comics,3,TRUE)
That would return the value from the 3rd column in our named range. If we wanted to return the 4th, just change the 3 to a 4.