Vlookup Formula is showing error

**kh0515** · 01-12-2009, 01:40 PM

I'm new to using excel and I have project that I need to finish but I can't seem to get the formula working.
Basically, I'm using Vlookup to track inventory. All of my inventory items are on seperate workbooks and my formula is on the last workbook. I'm tracking by codes (in column A I have all product codes and in column B i have the quantity). All products are listed singularly (eg- I have 10 of something there are ten rows with the same item number) and there is a total at the end of each item code.
My problem is that the vlookup is only catching the first number and either i get an #N/A error or quantity of 1, where there should be 2,5 or 10.
Please help!!

Thanks

**NBVC** · 01-12-2009, 01:43 PM

Are you trying to sum the totals where matches occur?

Can you also show us the actual formula you are using?

Are there times where there are no matches to be found?

**kh0515** · 01-12-2009, 02:32 PM

This is the formula i'm using:
VLOOKUP(B4,FORMULA!$A$2:$B$1710,2,FALSE)

I want to show the totals from my 'formula' tab onto each corresponding item number:
inventory page
D37OU-ING-E TOP XT USA PRO 600 #N/A
Formula page
D370U-ING-E 1
D370U-ING-E 1
D370U-ING-E 1
D370U-ING-E 1
D370U-ING-E 1
D370U-ING-E 1
D370U-ING-E Total 6

All of the items on my workbooks should all have a match.