Help with LOOKUP

[JOSHSKORN]

I'm on Excel 2019. I have a workbook with two sheets. On sheet #2, I'm trying to populate a table with data into a column, by looking up data from Sheet #1. The data in Sheet #1 is in rows.

Sheet #1:

Number	Name	SomeInfo	Location
1	First Thing	Info1	First Location
2	Second Thing	Info2	Second Location

Sheet #2

Name	Some Info	Location
First Thing	Info1	First Location
Second Thing	Info2	Second Location

I want to lookup Column A, sheet 2 into Column B, Sheet 1, then return Column C from Sheet 1 into Column B into Sheet #2, and also return Column D from Sheet 1 into Column C into Sheet 2. Basically lookup "Name" and return SomeInfo and Location into their respective columns into Sheet #2.

I'm mixed up on how to use HLookup/VLookup/Match/Index, etc. Can someone help me understand what to use and how to find what I want?

 

[Joe4]

Have a look here. It will explain exactly how to use VLOOKUP and even shows you examples.

VLOOKUP function - Microsoft Support

Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.

support.microsoft.com

It looks like your situation should be a pretty simple straightforward solution of using VLOOKUPs in those two columns.