Advance Excel || 1) VLOOKUP example, using an exact match

 

You have the following table:

Product ID	Product Name	Available Stock	Price
2345	Pen	500	28
5457	Pencil	234	7
9823	Eraser	155	13
1233	Notebook	122	39
2344	Folder	167	24

You've been asked to come up with a way to check the price of a product when a product ID is typed into a given cell

Product ID	2345
Price	?

.