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

7 thoughts on “Data fetching from multiple Tables

  1. ig

    Howdy! I know this is somewhat off topic but I was wondering which blog platform are you using for this site?
    I’m getting tired of WordPress because I’ve had issues with hackers and I’m looking at alternatives for
    another platform. I would be fantastic if you could point
    me in the direction of a good platform.

  2. Simon

    I have learn some excellent stuff here. Definitely price bookmarking for
    revisiting. I wonder how so much effort you place to make this type of great informative web site.

  3. Marcy

    Write more, thats all I have to say. Literally, it seems as though you relied on the video to make your point.
    You definitely know what youre talking about, why throw away your intelligence on just posting
    videos to your site when you could be giving us something enlightening
    to read?

  4. check success

    Hello my dearest friends. Thank you very much for writing and publishing this educational article! Wold you mind to share more details on the tables, please?

  5. 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,

  6. 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.

Comments are closed.