Hi, I have 2 columns with data (lets say A and C). I want to (in another
column, say B) put a formula in that finds if a value in column A and looks
to see if there is a match in column C (not necessarily on same row). If
there is a match I want to input a value which exists in a 4th column in the
same row as the matched value in column C. e.g:

Col A Col B (formula here) Col C Col D
dog No match bear xxx
cat No match mouse vvv
mouse vvv lion xxx

So...if a value from column A exists in Col C (e.g. mouse) then in column
B i want to extract the value from col D (e.g. vvv), otherwise say 'no
match'. So both two and three.

Is this possible?