Return a value from a data set

Solved/Closed
Surya - Jun 7, 2010 at 05:57 AM
 Surya - Jun 7, 2010 at 08:22 AM
The problem is I have number 1 to 10 in A2:A11 and number 10,20,30....100 in B1,C1,D1..... K1 and there are corresponding values in the cells under these.

As an example, if I have two more cells somewhere far off this table. Now, i want excel to see the values in those cells and compare the value in first cell with any of the A2:A10 and value of the second cell with any of the B1:K1 and return the underlying value into someother cell. I tried many functions but its going nowehre. It would be great if someone can suggest

3 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Jun 7, 2010 at 05:58 AM
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
1
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Jun 7, 2010 at 07:04 AM
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)))
1
Thanku very much..it worked perfectly well
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
0