Hi, I have a list of text values I need to search a range in a workseet. The range is just one column. I need to search that column "E" and then return the value in the same row but from column C. I tried using INDEX ARRAY but that didn't work.
Hoping VBA could be a solution. It has been a while since I have used VBA so I am a little rusty.