Excel - V-lookups

Asked By kanstru on 12-Sep-07 11:08 PM
Hello,
I was wondering if anyone could tell me where I could learn or research more
about V-lookups.  I saw somebody use v-lookups to cross reference two excel
data sets and find the entries that do not match.  I don't know how they were
able to compare these two data sets using v-lookup tool.  If anybody could
tell me how they did this or tell me where I could look to learn this I would
appreciate it.

Thanks,
Chris




Ragdyer replied on 12-Sep-07 11:25 PM
Debra Dalgleish has several web pages dedicated to the function.

Check out this link:

http://www.contextures.com/xlFunctions02.html

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
more
excel
were
would
kanstru replied on 15-Sep-07 09:02 PM
Thank you Debra for your response but unfortunately it does not answer my
question.  I am looking to compare to separate data sets and cross reference
those to find the values that are not found on both data sets.  If you know
how to do this or if anybody else does I would appreciate some help.

Thanks,
Chris
Ragdyer replied on 16-Sep-07 12:38 AM
One way in which it can answer your question:

Say you have in list 1 at:
Column A
1   ant
2   pig
3   cat
4   mouse
5   dog
6   rat
7   fly

And on list 2 at:
Column E
1   rat
2   owl
3   pig
4   fly
5   cat
6   dog
7   ant

In B1, enter this formula:

=VLOOKUP(A1,E$1:E$7,1,0)
And copy down to B7.

Next, in F1 enter this formula:

=VLOOKUP(E1,A$1:A$7,1,0)
And copy down to F7.

NOW, B1 to B7 will display the matching  data from Column E.
If there is no match found to Column A in Column E, you'll see a #N/A error.

The same thing will happen in F1 to F7, pertaining to matches found in
Column A.


Is that, or is that not, the type of information you're looking for?
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

reference
know
-
!
-
research
they
could
I