Data fetching from multiple Tables

 

I need to find the marks from the two different tables, 

 

TABLE 1

  TABLE 2
NAME PHY CHEM MATHS   NAME HINDI SST EVS
RAJNEESH 38 66 76   VAIBHAV 99 57 60
TARUN 91 85 39   SONAL 62 54 62
HITESH 39 78 44   DERRY 52 52 93
WAIZ 69 33 95   TONY 52 68 78
                 
                 
  NAME DERRY            
  SUBJECT MATHS            
  MARKS              

By: RAJNEESH

2 thoughts on “Data fetching from multiple Tables

  1. D N Maru

    Hi

    Use Iferror, index, match. I have above copied your data in excel. Table 1 is A8 to D12; Table B is F8 to I12.

    Formula for Marks in in C17 would be :

    =IFERROR(INDEX(F8:I12,MATCH(C15,F8:F12,0),MATCH(C16,F8:I8,0)),INDEX(A8:D12,MATCH(C15,A8:A12,0),MATCH(C16,A8:D8,0)))

    Use can use absolute or relative references as desired.

  2. rajneesh

    Well, I tried using this, but it’s not performing, if possible kindly share the file through google drive, maybe i am making some mistake,

Leave a Reply

Your email address will not be published. Required fields are marked *