Match and index

 Blocked Profile -


ive been struggling the entire morning to figure out a formula.

i have two sheets, i want to match columnD on sheet2 to columnA in sheet1 but at the same time i need columnBs data in sheet1 to be dropped in the formula column in sheet2..


this is the formula i came two but its not giving me what i want :(

pleeeeeeeeeeeze take me out of my misary


1 reply

Dear Angel Face,

Please consider checking the solution to your problem in the below

similar post that has already been answered:

Thanks in advance.