Return a value from a data setSolved/Closed

Question

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

rizvisa1 · Answer

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

Surya · Answer

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

rizvisa1 · Answer

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)))

Return a value from a data set

3 replies

Subscribe To Our Newsletter!