VLookup Confusion

  • Thread starter Thread starter Tobor
  • Start date Start date
T

Tobor

I will take help from everyone who is willing to help. Let me explain and
give you an example. I have a inventory of about 246 line items I use these
parts on a daily bases. I have an Excel file of my original allotment and I
download a copy of this file from the server weekly showing all the changes
made that week. It is my desire to use vlookup to compare the weekly
downloaded file to the original file to keep my inventory accurate.



Now one part number will be in this from 7-77216-20 these types of part
numbers vlookup can find with out any problems.

The next part number will be in this form 89212031501 at the point the part
numbers are in this format vlookup will return an n/a I have all the cells
formatted to general. Out of the entire list of parts vlookup may find one
or two parts in this format. I know it is asking a lot but if you can help I
would appreciate it and I can send the file as an attachment (But only with
you permission).



If this conversation needs to go offline I can be reached a
(e-mail address removed).
 
Hi Tobor,

I will take a look at your workbook. Albeit I am seeking an answer for
VLOOKUP myself in this group.

Regards,
Howard
 
Hi Tobor
I used the following formula on sheet2 with a list of
your numbers in ColumnA.
Your part numbers were also listed in sheet1 in ColumnA
with a simple abc to p in ColumnB.

=VLOOKUP($A1,Sheet1!$A$1:$B$16,2,FALSE)

The only time I received the #N/A was when I change the
part number on Sheet1 to a number not on sheet2.
i.e changed 89212031501 to 89212031500

HTH
Bob C
 
Back
Top