Ask Your Question

search, match, and redirect result

asked 2017-05-16 20:41:09 +0100

thefinn2003 gravatar image

updated 2017-05-16 22:44:30 +0100

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:

any help would be greatly appreciated.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-05-17 00:20:22 +0100

Lupp gravatar image

updated 2017-05-17 00:41:45 +0100

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.)

edit flag offensive delete link more

answered 2017-05-20 22:00:47 +0100

thefinn2003 gravatar image

yes. thank you. i am your slave.

edit flag offensive delete link more


If the answer solves your question please tick the ✔.

m.a.riosv gravatar imagem.a.riosv ( 2017-05-21 01:08:07 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-05-16 20:41:09 +0100

Seen: 43 times

Last updated: May 20 '17