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
Gouws Posts 45 Registration date Sunday February 7, 2010 Status Member Last seen April 15, 2012 - Jan 20, 2011 at 04:55 AM
Related:
- Lookup name & return column value
- Display two columns in data validation list but return only one - Guide
- Https //accounts.google.com/sign in/v1/lookup - Guide
- Thunderbird return receipt - Guide
- If cell contains date then return value - Excel Forum
- Excel: If Date =, then enter a value ✓ - Excel Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jan 19, 2011 at 09:01 AM
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%, ""))
=IF(B2=Sheet1!K2, SUM(K2:K28)*1000%, IF(B2=Sheet1!J2, SUM(J2:J28)*1000%, ""))
Jan 20, 2011 at 04:55 AM