Re: V-lookups

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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 !
---------------------------------------------------------------------------

"kanstrup" <kanstrup@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9E216CFB-7924-421D-A2B5-F9AEFC93323B@xxxxxxxxxxxxxxxx
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" wrote:

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
!

--------------------------------------------------------------------------
-
"kanstrup" <kanstrup@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D0756FA8-3A77-41DA-BACE-B4BFFD543AC0@xxxxxxxxxxxxxxxx
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



.

Relevant Pages