Ask Your Question

Find or search a sheet and input value

asked 2018-07-12 06:42:47 +0200

winterpucks gravatar image

I have sheet 1 with two columns. Column A has a name and B column has a number value. In total there are 443 rows.

On sheet two I have another list of names in 1 column about 52 rows long.

On sheet 2 I would like a formula that finds the name on sheet 2 in column A sheet 1 and transfers the corresponding numerical value found in column B sheet 1 to sheet 2.

Thank you

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-07-12 06:51:43 +0200

JohnSUN gravatar image

It's trivial, it can be


if names in first sheet is unique or


in other case

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-07-12 06:42:47 +0200

Seen: 28 times

Last updated: Jul 12 '18