Help with Lookup

  • Thread starter Thread starter tomwesnick
  • Start date Start date
T

tomwesnick

I have an excel worksheet that has approximately 20,000+ records. I
would like to classify these recorded based on two columns. The first
column's name is "YB Description" and the other is "Sold Date". The YB
column mainly contains 4 digit numerical values, with approximately
300-400 records that are text, ie. "classified", "not verified",
"public use". The Sold Date column is pretty self-explanatory, all the
records are dates with the following formatting - M/D/Y. What I would
like to do is create a third column called YB/Sold that classifies the
records according to the the values in the YB column. I've been able to
create a simple lookup formula but I run into a problem when it comes
across the text values "Classified .... ". Is there a way I could
adjust the formula so that when it comes across theses three text
values it will look in the 2nd column, "Sold Date", and only use the
Year portion (M/D/Y) for the YB/Sold cell. I hope this all makes sense.

Tom.
 
The details of what you're asking are not clear to me, but does

=RIGHT(YEAR(VLOOKUP("Classified",A1:B10,2,0)),2)

help?

Alan Beban
 
anything with that many records in Excel is a waste of time.

Start using DATABASES for your DATA and throw Excel out the Window.
 
Sorry for not explain myself better. But I've figured out a solution to
my problem. I used a logic formula. Aaron the actual records I believe
sit in a Access database. I use excel just analyzing the data. Not to
familiar with Access.

Tom
 
Tom

Sorry you ran across Aaron, he tends to be on a mission that believes Access
is the answer to the universes issues. What you are doing with Access as a
data store and Excel as a reporting front-end makes perfect sense. Despite
what you may have been told by Aaron.

The interesting point you make about 'Not to familiar with Access.' is a
point Aaron refuses to accept can *ever* be the case.

Please feel free to ask any other questions you may have, despite the
unwelcoming attitude of Aaron

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
listen ****nut

Excel is for babies

it doesnt scale; it can't be used by multiple programs.

Office Web Components friggin rock.

I would reccomend throwing Excel in the trashbin and starting to learn
a program that is a LOT more powerful.

Access queries are EASY.

Macros are EASY.

With queries and macros; you can do almost anything in the world.

Macros in Access are all multiple choice; it's not like programming
hundreds of pages of Excel vba

good luck; back in '97 i was working for a company in a software
testing role; and they trained 30 of us in Access queries in about an
hour. I wrote hundreds of queries that summer; it was the best of
times.

-Aaron

-aaron
 
Back
Top