# search, match, and redirect result

beating my head against a wall trying to understand how to do this.

for every cell in column B, i want to search for a match in column A. for every match, i want to take the contents of the cell in column D on the same row as the key in column B, and put that result into the cell in column C on the same row as the match in column A.

unfortunately i don't have enough points to upload a file, but here's a link:

https://docs.google.com/spreadsheets/...

any help would be greatly appreciated.