Re: vlookup

From: JulieD (JulieD_at_hctsReMoVeThIs.net.au)
Date: 08/25/04 

Date: Wed, 25 Aug 2004 21:07:56 +0800

Hi

vlookup ISN'T used to extract values common to two lists, it's used to
return related data from one list given a lookup value. For example if i
have a table that has
Product Code Description Cost

and then on another *** i want to enter a product code and have the cost
appear in an adjacent column i would use VLOOKUP -
where the first parameter (lookup_value) would be the product code i enter
in the second ***, second parameter (table_array) is the table that i've
got above, third parameter (column number of return information) would be
3 - as it's the cost that i'm interested in and then false for an exact
match.

>From this post of yours and the previous ones ... i don't think VLOOKUP is
really what you're after. Frank posted a link to Chip Pearson's site which
is on extracting values common to two lists, which i would recommend you
have another look at. I've posted the link again below.
http://www.cpearson.com/excel/duplicat.htm#ExtractingCommon

Hope this helps
Cheers
JulieD

"dhess" <sseh1@aol.com> wrote in message
news:18F36955-3412-41F2-9593-CD0A3472C047@microsoft.com...
> I want to be able to use lookup to extract values common to two list. What
is
> the formual and do I input values in all the boxes in the drop down box???
> New to this.
>
> IE.number order
> 333 1111
> 999 5555
> 1111 333
> 5555 999
> 22222 22222
> How can I match the loan numbers up against each other ?
> --
> dhess