Hi, I'm trying to conjure up the easiest way to have some sort of function that will locate a text from column A in column B, and then return the value that is adjacent to that cell, in column C.
i.e:
(a) (b) (c) (d)
1) A B 2 =findzor(a1,b:b)
2) B D 4
3) C A 5
4) D C 9
so that the function finds the text in a1 in the b column and returns the value adjacent to the right, which would be 5.
tried using offset and match and it turns out i'm over my head
Bookmarks