Copy corresponding fields from other tab

[macnoel]

In have a spreadsheet (2016) with 2 tabs. In one tab I have a long list of numbers. These numbers correspond with information from the second tab. The problem is that the second tab has lots more numbers then the first tab. So what would I like to do. Say, in the first tab I have a number (for instance 21546). I would like to add specific fields from the second tab from the row that has the same number. So I need a formula or something that when I put this in an empty field besides the number on tab 1, fills with a specific field from the row of the second tab with that same number. Is that possible?

 

[sergioMabres]

Hi macnoel
Yes it is possible, and is one of the most useful formulas in excel, read about VLOOKUP
Cheers
Sergio