We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Show the value from a list for the adjacent cell

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

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

2 Answers

Sort by » oldest newest most voted

answered 2020-04-27 18:04:44 +0200

inJesus gravatar image
edit flag offensive delete link more

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

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


It works fine when I use semicolon instead of comma

inJesus gravatar imageinJesus ( 2020-04-27 17:45:25 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 475 times

Last updated: Apr 27 '20