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

Lookup name & return column value
Display two columns in data validation list but return only one - Guide
If cell contains date then return value ✓ - Excel Forum
Excel "IF" function w/ date in test cell ✓ - Excel Forum
Excel formula to check if cell contains a date - Excel Forum
Zuma return - Download - Puzzle

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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%, ""))

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!!

Similar discussions

WOW equipment return

Find my Gmail account

If a cell contains any text then add a value

If cell = date return yes or no.

help me to add particular cells

Similar discussions

Subscribe To Our Newsletter!