Ask Your Question
1

Show the value from a list for the adjacent cell

asked 2018-08-25 16:32:37 +0100

inJesus gravatar image

Hi :-)

I need a function: If a search string (not case sensitive) is contained in an array of cells, show the value from a cell in an adjacent array as the function result (adjacent to the cell of the search string).

Example file attached. C:\fakepath\Examples paste fitting cell content.ods Would be happy about the solution in the example file.
No macros please.

Blessings, Klaus

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2018-08-26 09:12:45 +0100

It can be done using VLOOKUP but you have to reformat your F column. In F column, keep only one item per row.

Then, in C3: =VLOOKUP(A3,F:H,2,0) D3: =VLOOKUP(A3,F:H,3,0)

Drag the handle till your data exists.

image description

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-08-25 16:32:37 +0100

Seen: 29 times

Last updated: Aug 26 '18