Combining hlookup and vlookup
Posted by shane evatt on March 30, 2001 6:09 AM
I have a spreadsheet with multiple worksheets. I have a master worksheet with variables in the B column that represent industries (retail, autos, etc) and variables in row 7 that represent dates (Dec00, Sep00, etc). I need a formula that will act somewhat like a 2 variable query that will find the amount on a prescribed worksheet that matches the two variables (e.g. amount for 'retail' as of 'Dec00'). I tried to nest a vlookup in an hlookup but had no success. Any advice?