Skip to main content

Advance Excel || 3) HLOOKUP example, using an exact match

 






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

Popular posts from this blog

SAP MM (Materials Management)

  SAP Materials Management (SAP MM)- Organizational structure/ Company structure What is a MM? Materials management is  the process of planning and controlling material flows . It includes planning and procuring materials, supplier evaluation and selection, purchasing, expenditure, shipping, receipt processes for materials (including quality control), warehousing and inventory, and materials distribution. Ø    How to Start SAP server? /POWER ON (Ctrl +B) Ø    How to POWER OFF (Ctrl + E) SAP Server? Ø    How to Suspend SAP Server? (Ctrl + J) ü    ECC 6.0 Latest version of SAP server ü    ECC (Enterprise Central Components) ü    SPRO (SAP Project Reference Object) ü    IMG (Implementation Guide) ü    Ctrl + Alt + Enter (Full Screen) ü    Going back to SAP EASY ACCESS screen . /N (forward slash & N) in command window . Transactions Code (T- code) Go to Additional Information -> Additi...

Advance Excel || 5) How to create student Marksheet in Excel ? || PART -B || Using IF Condition

  Advance Excel || 5) How to create student Marksheet in Excel ? || PART -B || Using IF Condition

TallyPrime Volume-2 (Purchase & Sales voucher, Bank Payment, Bank Receipt, Cost Centers, Interest Calculations, Use separate Actual & Billed Qty columns in invoice, IGST, Multiple Pric, sales Voucher class, IGST, Multiple Price Level)

  How to Enable GST in TallyPrime ? Press F11 Features -> Taxation (Enable Goods & Service Tax (GST) -> Yes