Double Vlookup (1 Viewer)

[GregVB]

Is it possible to nest a vlookup within another vlookup formula? Everytime i try, i get a #n/a. I would think that it should work, but i'm not positive on that. THe only way i've gotten around it is to use concatenate, but thats adds another step that i dont really want to do

 

[shades]

Can you attach an example. BTW, INDEX/MATCH is much more flexible than VLOOKUP.
________
Buy no2

 

[GregVB]

I achieved the results i wanted by using dsum. I needed to use multiple criteria to sum something, and dsum worked like a charm.

 

[shades]

Okay, the OP didn't mention anything about summing up, but lookup. Multiple criteria summing can also be accomplished by SUMPRODUCT.
________
Ford Proving Grounds