This is a little different, but I think will return the result you
seek..........
=IF(ISNA(VLOOKUP(B11,Sheet1!A:A,1,FALSE)),"Not
Listed",VLOOKUP(B11,Sheet1!A:A,1,FALSE))
Vaya con Dios,
Chuck, CABGx3
"phil2006" wrote:
Is it possible to condense the following formula as it is too long.
=SUM(IF(sheet1!$A$3=B11,sheet1!B$3)+IF(sheet1!$A$4 =B11,sheet1!B$4)+IF(sheet1!$A$5=B11,sheet1!B$5)).. .etc
The problem is that I have around 160 rows on sheet 1 which need adding
in.
Thanks
Phil
--
phil2006
------------------------------------------------------------------------
phil2006's Profile: http://www.excelforum.com/member.php...o&userid=35092
View this thread: http://www.excelforum.com/showthread...hreadid=549415