V and H lookup in an and statement


Posted by Paul B. Tillman on December 16, 1999 8:05 AM

I need to pull a value from a table based on a range of number in both the vertical and horizontal format. I think the way to do this is to combine the vlookup and hlookup within an if, and statement, but as of yet have not been succesfull in getting it done. Does Excel have a built in function for this? I have been unable to find one. If not, could you provide the statement required.

Thanks,

Paul



Posted by Chris on December 16, 1999 9:05 AM

Paul,

I think you'll have better luck combining the index and match functions. I think MrExcel may even have an example of this.

Chris