vlookup + match
Hello. I need help with a formula combining vlookup and match. Somehow, the return is not correct. My formula right now is: VLOOKUP($B9,$B$2:$B$5,MATCH($A9,$A$2:$A$5,0),FALSE)
But it’s wrong apparently. Why?
Hello. I need help with a formula combining vlookup and match. Somehow, the return is not correct. My formula right now is: VLOOKUP($B9,$B$2:$B$5,MATCH($A9,$A$2:$A$5,0),FALSE) But it’s wrong apparently. Why? Read More