Add 2 vlookups in 1 cell, excel 2010

[moppie]

Hi, can someone help me out on this? I tried the solution given back in 2008 for Excel 2007, but this does not add/return the value...

[Ron Coderre]

Welcome to the forum.

Please post an example of what you want to do...include the forumulas you have tried (they can help us better understand your issue)

[moppie]

Hi Ron,

In worksheet A I want the sum of the goods in transit (worksheet B) and the goods in stock (worksheet C)
I tried =SUM(IFERROR(VLOOKUP(C2,worksheet B,6,0),0),IFERROR(VLOOKUP(C2,worksheet C,6,0),0))