Advance Excel || 3) HLOOKUP example, using an exact match
You have the following table:
Product ID | 2345 | 5457 | 9823 | 1233 | 2344 |
Product Name | Pen | Pencil | Eraser | Notebook | Folder |
Available Stock | 500 | 234 | 155 | 122 | 167 |
Price | 28 | 7 | 13 | 39 | 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 | Price |
2345 | ? |
Product ID | Price |
5457 | ? |
.
Comments
Post a Comment