Hello, can anyone help me? so i've been trying to use VLOOKUP to return a value from a data table from another worksheet, BUT then VLOOKUP returns 0 and pick FIRST MATCH VALUE. I realized why it returns 0 because the source data table has zero/blank values and while VLOOKUP function only pick first match value, i guess (correct me if im wrong).So, what ive been confused about is, What function should i use to return LAST MATCH value from a data table from another worksheet ?
here i attach sampe file
i want to replace tht function. I have no idea what function am is supposed to use Any idea? Thanks in advance