Hi All,

Im having a bit of trouble here. Im trying to sum the results of different VLOOKUP's, the probalem im having is i dont think excel is realsing the results of the vlookups are numbers as they are the result of a formula themselves.

So im trying a formula like this:

=(VLOOKUP(D4,G4:I203,2,FALSE)-(VLOOKUP(D4,D4:F203,2,FALSE)))

But the cells the VLOOKUP on its own would bring is the result of a formula itself.

Any help would be great!