You are reading a single comment by @moocher and its replies.
Click here to read the full conversation.
-
yeah index match should work?
-
Index / Match
You use match to find the position of the thing you're looking for, then you use that as the position for index.First one is vlookup, searching the 1st column and returning the 2nd
Second one is index/match, searching the 2nd column and returning the 1st
-
Xlookup is the way the cool kids are going now.
.Rodders
duncs
aggi
@moocher
I want to lookup A1 in column D and return the value from column C - so a negative vlookup.
Match works doesnt it? or xlookup?