Fetching data from another sheet

Hello!

While I have somewhat of a good knowledge of Excel, I'm currently trying to implement something and my brain seems to not be working correctly.

So I have one sheet, where I hold the data, for instance column A holds the names, column B holds a value. Let's say there are 300 rows in total.

On a second sheet I would like it so that when I enter one of the names in a specific cell, it automatically grabs the value assigned to it from the first sheet and displays it in a column next to the name.

Thanks in advance!

EDIT: sample now included.

Welcome to the forum.

VLOOKUP, INDEX MATCH or XLOOKUP shuld work for you.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Try:

=IFERROR(VLOOKUP(A1,Sheet1!$A:$B,2,FALSE),"")