Assigning Label to Data in a Date Range

Greetings!

I'm still learning a lot about excel, so any help would be appreciated.

I need to assign a vender ID to transactions within a certain date range.
So, for example, what I need is some kind of formula that would, in a new column, assign the ID 200 to every row that has a date between 01/01/10 and 01/31/10.

Thanks!

Sounds like a vlookup might work for you.

Suppose I have a table in Sheet2 that looks like:

Please Login or Register  to view this content.

Then in your table you could use:
=VLOOKUP(A1,Sheet2!$A$2:$B$11,2) {replacing A1 w/ your proper cell reference and extending $B$11 downward for as many rows of dates/IDs as you need}

Note that the formula needs the $ signs in the Sheet2 reference to keep it from changing as you copy it downwards in Sheet1.