Lookup name & return column value

Solved/Closed
Gouws Posts 45 Registration date Sunday February 7, 2010 Status Member Last seen April 15, 2012 - Jan 17, 2011 at 06:33 AM
Gouws Posts 45 Registration date Sunday February 7, 2010 Status Member Last seen April 15, 2012 - Jan 20, 2011 at 04:55 AM
Hello,

I am looking for assitance with a formula and all help would really be appreciated.

I have 2 sheets sheet 1&2,on Sht1 is cells J2 & K2 where a name can be put in. On sht2-B2 i got a name eg "SAM".I have put a formula in Sht2-B3 that look at Sht1-J2 and if the name SAM appear it SUM J3:J28*1000%.FORMULA used:=IF('Sheet1'!J2=Sheet2!B2,1,SUM('Sheet1'!J3:J28)*1000%). I am trying to double it up to say look in SHt1-J2 and K2 and if "SAM" appear in Sht1-K2 SUM K2:K28*1000% and when "SAM" is in Sht1-J2 SUM J3:J28*1000%.

Thanks
Gouws




1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jan 19, 2011 at 09:01 AM
would not some thing like this work ?


=IF(B2=Sheet1!K2, SUM(K2:K28)*1000%, IF(B2=Sheet1!J2, SUM(J2:J28)*1000%, ""))
1
Gouws Posts 45 Registration date Sunday February 7, 2010 Status Member Last seen April 15, 2012
Jan 20, 2011 at 04:55 AM
TX rivisa1 it works super!!
0