VLookup Help Please

[StephenSmith]

Hiya and good afternoon to everyone

I have created a workbook in excel 2013 and am struggling with the vlookup formula and was hoping to get some help here please.

I have attached the workbook for reference, and what it is I would like to be solved is on sheet 1 which I have called STOCK for a vlookup formula to be entered in I2 to look for the amount of sales corresponding to the DESCRIPTION on STOCK from sheet 2 called SALES in the DESCRIPTION column

I hope that makes sense

Many Thanks

Steve

[Jonmo1]

Well, you don't have any data entered on the Sales tab...

But I would say you want Either..
=VLOOKUP(C2,SALES!C:D,2,FALSE)

or if the Description will appear multiple times on the sales sheet, and you want to SUM them all together..
Then
=SUMIF(SALES!C:C,C2,SALES!D:D)

[Tony Valko]

There's no data on the Sales sheet.

Put some data on the Sales sheet then show us a few examples of the results that you expect.

[vorabha]

@stephenSmith

few of the Rules for Vlookup you need atleast one unique data in Sheet named "Stock" as well as "Sales" to match with,
else your data in sales sheet of duplicate of Stock sheet will always pick first description .....

other wise your I2 formula would be =VLOOKUP(C:C,SALES!C:D,2,0)



BhaVesH

[StephenSmith]

thanks for that I have amended the workbook which is now attached, and have added examples on sheet 2, just need the formula to add up how many sales a product has made

thanks again

[Tony Valko]

Not sure...

Does this do what you want?

Entered in I2 and copied down:

=SUMIFS(SALES!D:D,SALES!B:B,STOCK!B2,SALES!C:C,STOCK!C2)

[StephenSmith]

thank you all so much for all your help

[Tony Valko]

You're welcome!