Return a value from a data set
Solved/Closed
Related:
- Return a value from a data set
- Display two columns in data validation list but return only one - Guide
- Tmobile data check - Guide
- Thunderbird return receipt - Guide
- How to reset safe folder password without losing data ✓ - Android Forum
- Data transmission cable - Guide
3 responses
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
7 Jun 2010 à 05:58
7 Jun 2010 à 05:58
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
7 Jun 2010 à 07:04
7 Jun 2010 à 07:04
Try this
=INDEX(A:K, MATCH(a13,A:A,0), MATCH(b13,1:1, 0))
perhaps better would be
=IF(OR(ISERROR(MATCH(a13,A:A,0)), ISERROR(MATCH(b13,1:1, 0))), "ERROR HERE", INDEX(A:K, MATCH(a13,A:A,0), MATCH(b13,1:1, 0)))
=INDEX(A:K, MATCH(a13,A:A,0), MATCH(b13,1:1, 0))
perhaps better would be
=IF(OR(ISERROR(MATCH(a13,A:A,0)), ISERROR(MATCH(b13,1:1, 0))), "ERROR HERE", INDEX(A:K, MATCH(a13,A:A,0), MATCH(b13,1:1, 0)))
https://docs.google.com/spreadsheets/d/1xFtUXoc_YyIUciosQ0Jarm93W7u1eUMFlS9Lbpw0a3k/edit?hl=en&hl=en
this is the spreadsheet... now given the values of A13 and B13 will be given and will correspond to the headings data, we need the answer to be the value which is the intersection.
I mean for given example, when A13 is 50, B13 is 6, answer should be 175 and when A14 is 10 and B14 is 8, answer should be 250.
i think now its clear. can u kindly help
this is the spreadsheet... now given the values of A13 and B13 will be given and will correspond to the headings data, we need the answer to be the value which is the intersection.
I mean for given example, when A13 is 50, B13 is 6, answer should be 175 and when A14 is 10 and B14 is 8, answer should be 250.
i think now its clear. can u kindly help