V-lookups

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kanstrup - 13 Sep 2007 04:08 GMT

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

Reply to this Message

Ragdyer - 13 Sep 2007 04:25 GMT

Debra Dalgleish has several web pages dedicated to the function.

Check out this link:

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

Signature

HTH,

RD

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

> Hello,
> I was wondering if anyone could tell me where I could learn or research more
[quoted text clipped - 6 lines]
> Thanks,
> Chris

Reply to this Message

kanstrup - 16 Sep 2007 02:02 GMT

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

> Debra Dalgleish has several web pages dedicated to the function.
>
[quoted text clipped - 16 lines]
> > Thanks,
> > Chris

Reply to this Message

Ragdyer - 16 Sep 2007 05:38 GMT

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?

Signature

> 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
[quoted text clipped - 28 lines]
> > > Thanks,
> > > Chris

Reply to this Message

Rate this thread: