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/d/1IKLb_-mKUA8JEZ6w_reRY5scg6lgLv7d1dv4wX8FYTk/edit?usp=sharing
any help would be greatly appreciated.