Search, match, and redirect result

[thefinn2003]

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.

[Lupp]

If I understood correctly you can do this using two helper columns first matching the content of B rowwise against the column of vakus in A, and then the index of each row against the results found in the first helper column. Based on the results in the second helper column you then can pick the elements you want.
See this attached demo. If the column of results you want to pick from is incomplete, you may get irritating zeros. Ask again if this is relevant for you.

I would conclude that an item in column A only can get assigned anything if it also occurs in column B. Now I would only need to find the matching row in B and the to take the content of that row in coulumn D. Much simpler.
See sheet 2 of the demo.

The task itself is not described unambiguously if it is not assured that any entry in column A and in column B as well can only occur once at most.

(Spreadsheet formulae cannot redirect anything. A formula can only calculate a result and return it to the cell the formula is contained in for display.)

[thefinn2003]

yes. thank you. i am your slave.

[mariosv]

If the answer solves your question please tick the .