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.
<colgroup><col width="87"><col width="66"><col width="66"><col width="66"></colgroup> <tbody>
[TD="width: 87"]
[/TD]
[TD="width: 66"] Category [/TD]
[TD="width: 66"] year start [/TD]
[TD="width: 66"] year end [/TD]
</tbody>
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.
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>
[TD="width: 87"]
[/TD]
[TD="width: 66"] Category [/TD]
[TD="width: 66"] year start [/TD]
[TD="width: 66"] year end [/TD]
</tbody>