If you are summing a range your best bet is to use INDEX but you need to
indentify the 2 cells (no need for ADDRESS really) maybe using MATCH

--

Regards,

Peo Sjoblom

"hydro1guy" wrote in message
...
THat works but I want to sum the range of cells between the two. I think I
may have to use address but cannot get it to work. How else can I identify
the actual cell address for my range?

"Nick Hodge" wrote:

Hydro1guy

Just add the two lookups together

=VLOOKUP(Your_Vlookup)+HLOOKUP(Your-Hlookup)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"hydro1guy" wrote in message
...
I have identified two cells in a table using vlookup & hlookup. I want
to
sum the cells referred to by the lookups.