Ask Your Question
0

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
1

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

JohnSUN gravatar image

It's trivial, it can be

=VLOOKUP(A2;$Sheet1.A:B;2;0)

if names in first sheet is unique or

=SUMIF($Sheet1.A:A;A2;$Sheet1.B:B)

in other case

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 21 times

Last updated: Jul 12