Lookup name & return column value
Solved/Closed
Gouws
Posts
45
Registration date
Sunday 7 February 2010
Status
Member
Last seen
15 April 2012
-
17 Jan 2011 à 06:33
Gouws Posts 45 Registration date Sunday 7 February 2010 Status Member Last seen 15 April 2012 - 20 Jan 2011 à 04:55
Gouws Posts 45 Registration date Sunday 7 February 2010 Status Member Last seen 15 April 2012 - 20 Jan 2011 à 04:55
Related:
- Lookup name & return column value
- Thunderbird return receipt - Guide
- Https //accounts.google.com/sign in/v1/lookup - Guide
- Excel column number - Guide
- How to delete a column in word - Guide
- Tweetdeck expand column - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
19 Jan 2011 à 09:01
19 Jan 2011 à 09:01
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%, ""))
20 Jan 2011 à 04:55