VLookUp in Excel
 

I'm trying to complete a simple comparison of two columns of asset #s
and locate any missing numbers from the smaller of the two. I'm
getting errors everytime I try. Any help you can provide?

VLookUp in Excel
 

Let's assume the data you are checking is in column A of Sheet 1 and the data
you are checking it against is in column A of Sheet 2. Try something like
this

=VLOOKUP(Sheet1!A1,Sheet2!$A$1:$A$100,1,FALSE)

If there is a match, this will return the matched value. Also note that
there needs to be an exact match for you to get a returned value. If there
is no exact match, you'll see #N/A.

" wrote:

I'm trying to complete a simple comparison of two columns of asset #s
and locate any missing numbers from the smaller of the two. I'm
getting errors everytime I try. Any help you can provide?

VLookUp in Excel
 

On May 5, 6:08 am, Barb Reinhardt
wrote:
Let's assume the data you are checking is in column A of Sheet 1 and the data
you are checking it against is in column A of Sheet 2. Try something like
this

=VLOOKUP(Sheet1!A1,Sheet2!$A$1:$A$100,1,FALSE)

If there is a match, this will return the matched value. Also note that
there needs to be an exact match for you to get a returned value. If there
is no exact match, you'll see #N/A.



" wrote:
I'm trying to complete a simple comparison oftwocolumnsof asset #s
and locate anymissingnumbersfrom the smaller of thetwo. I'm
getting errors everytime I try. Any help you can provide?- Hide quoted text -

- Show quoted text -

Thanks for the input.

I completed and had this formula: =VLOOKUP(C2,'redc 5-4-7.xls'!$I$2:$I
$106,2,FALSE). The VLookUp is supposed to compare all the Numbers
from Colum C on my first sheet to the colum that I specifed on the
second sheet ('redc 5-4-7.xls'!$I$2:$I$106). I then created another
column in the first worksheet, colum 2 to return the results to. I
only came back with one match?

It may be easier if I explain what I am doing. I know that I have 95
specific numbers on the fist sheet. I only have 94 of those 95 on the
second sheet. How do I find the missing number, is the question?
While 95 is not that difficult to go through and sort, then cut and
paste the two next to each other and maually compare, when I get
hundreds of numbers to compare and notice that I am missing 5 out of
say 500, then this becomes a time consuming issue. Shouldn't this
VLookUp be searching the first number in Column C with all of the
numbers in the Column on sheet two that I specificed and then populate
the number I'm searching for in the new column I've made( if there is
a match)? The formula continues for the second number and so forth?
The two columns I'm comparing don't have to be in numerical order, do
they?

Sorry for all the questions, I've seen this formula work and when it
does, it works well....just need some direction.

Thank you.

VLookUp in Excel
 

There's at least one problem with your formula:

=VLOOKUP(C2,'redc 5-4-7.xls'!$I$2:$I$106,2,FALSE)

You're trying to bring back column 2 of a single column range (I2:I106). If you
really wanted to bring back the second column of that range, then that range has
to have at least two columns:

=VLOOKUP(C2,'redc 5-4-7.xls'!$I$2:$J$106,2,FALSE)

But if you're only looking for a match, you could use:

=isnumber(match(c2,'redc 5-4-7.xls'!$i$2:$i$106,0))

If you see True, then there is a match. If you see false, then there is no
match.

And just a curiousity question....

Do you really have a worksheet named "redc 5-4-7.xls" in that workbook. It has
a pretty unusual name (including the .xls). There's no problem with the name,
though. I was just curious.



wrote:

On May 5, 6:08 am, Barb Reinhardt
wrote:
Let's assume the data you are checking is in column A of Sheet 1 and the data
you are checking it against is in column A of Sheet 2. Try something like
this

=VLOOKUP(Sheet1!A1,Sheet2!$A$1:$A$100,1,FALSE)

If there is a match, this will return the matched value. Also note that
there needs to be an exact match for you to get a returned value. If there
is no exact match, you'll see #N/A.



" wrote:
I'm trying to complete a simple comparison oftwocolumnsof asset #s
and locate anymissingnumbersfrom the smaller of thetwo. I'm
getting errors everytime I try. Any help you can provide?- Hide quoted text -

- Show quoted text -

Thanks for the input.

I completed and had this formula: =VLOOKUP(C2,'redc 5-4-7.xls'!$I$2:$I
$106,2,FALSE). The VLookUp is supposed to compare all the Numbers
from Colum C on my first sheet to the colum that I specifed on the
second sheet ('redc 5-4-7.xls'!$I$2:$I$106). I then created another
column in the first worksheet, colum 2 to return the results to. I
only came back with one match?

It may be easier if I explain what I am doing. I know that I have 95
specific numbers on the fist sheet. I only have 94 of those 95 on the
second sheet. How do I find the missing number, is the question?
While 95 is not that difficult to go through and sort, then cut and
paste the two next to each other and maually compare, when I get
hundreds of numbers to compare and notice that I am missing 5 out of
say 500, then this becomes a time consuming issue. Shouldn't this
VLookUp be searching the first number in Column C with all of the
numbers in the Column on sheet two that I specificed and then populate
the number I'm searching for in the new column I've made( if there is
a match)? The formula continues for the second number and so forth?
The two columns I'm comparing don't have to be in numerical order, do
they?

Sorry for all the questions, I've seen this formula work and when it
does, it works well....just need some direction.

Thank you.

--

Dave Peterson