# 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
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)))
Thanku very much..it worked perfectly well