I need it in one equation the reference in the row (abc2) and the column are
sourced from another sheet as to what they are... Its a little more complex
than just using V and H lookup

"Martin" wrote:

Look at Vlookup and Hlookup in help
--
Martin


"CDog" wrote:

Trying to get value to return from a table where the row and column reference
intersect and to bring that value back to the previous worksheet.

EG table looks a litle like this
A B C D E F
abc1 10 12 14 16 22 57
abc2 20 22 25 29 34 60
abc3 50 67 85 99 105 110

So say I wanted to bring back the value where abc2 and c intersect = 25

How do I do this?