Lookup value from one sheet to another

[Vegaanders]

Hi all!

As a groundlevel user, the following problem I need help to solv

Case

In sheet 1 I have 1500 lrows with products. Three of the columns are Name, Category and Category ID. The two first columnes are filled in but the ID column is empty:

In sheet 2 I have two columns. Categories and Category ID.

Now I want to have a formula in the empty ID column that take the ID for the category from Sheet two.

Is this possible?

Thanks in advance

Anders, Cyprus

 

[Joe4]

See VLOOKUP
https://www.techonthenet.com/excel/formulas/vlookup.php

 

[Vegaanders]

That was the solution! Thanks a lot

Anders