Let's assume you have a value in cell E23 that you want to look for in
Range G22:L22. If found, average the range of G22:L22. Use this
formula:

=IF(NOT(ISNA(HLOOKUP(E23,G22:J22,1,0))),AVERAGE(G2 2:J22),"NOT FOUND")

Is this what you are looking for?


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=466285