Forum Topic

excel macro programming

  • there are 2 approach to yield the output:
    OUTPUT 1:
    Note: Col C & E is required for Vlookup syntax. You can hide it on your sheet.
    Formula : H1
    =IF(VLOOKUP(F1,B:C,2,FALSE)=VLOOKUP(G1,D:E,2,FALSE),"Matched on ROW " & VLOOKUP(G1,D:E,2,FALSE),
    A B C D E F G H
    1 1.234 1 5.367 1 1.32 3.245 Matched on ROW 4
    2 3.785 2 6.258 2 6.335 5.358 #N/A
    3 9.334 3 10.123 3 3.785 6.258 Matched on ROW 2
    4 1.32 4 3.245 4 3.356 8.879 #N/A
  • OUTPUT 2:
    Formula : F1
    =IF(INDEX(A:B,MATCH(D:D,B:B,0),1)=INDEX(A:C,MATCH(E:E,C:C,0),1),"Matched Found on ROW : " & INDEX(A:C,MATCH(E:E,C:C,0),1), "Not Found")
    A B C D E F
    1 1.234 5.367 1.32 3.245 Matched Found on ROW : 4
    2 3.785 6.258 6.335 5.358 #N/A
    3 9.334 10.123 3.785 6.258 Matched Found on ROW : 2
    4 1.32 3.245 3.356 8.879 #N/A

    hope it helps...good luck...
  • thanks, i try ko ito. although i would appreciate kung kumplete formula. hindi ko kasi alam kung saan ang range noong nakasulat na columns.

    -- edited by alexgutz on Jul 12 2017, 09:29 PM
  • complete formula na yan, copy paste mo nlng from top to bottom ung formula... try to analyze din, color coded naman yan wag masyado mgrely sa.... got the point? hehe...
  • triny ko hindi gumana...hehehe...pero nakita ko na yung approach...salamat ulit.
  • =IF(MATCH(D1,B:B,0)=MATCH(E1,C:C,0),"Match on row "&INDEX(A:A,MATCH(D1,B:B,0)),"Not Found")
    Yan pala nagiging formula. Salamat at nakuha ko ang idea.
  • ^ur welcome... it's always LOGICally Thinking when it comes to problem solving. mpa formula pa iyan or coding, it all adds up... so san ba ang buffet lunch/dinner? hehe jowk...