Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 376
  • Last Modified:

Excel lookup macrofor dividend

Hi Experts,

Can anyone help me ?

I want create a  lookup and  divide  formula in Cell O45   .
It can  search from  Sheet   M_ITEM.DBF,the corresponding    "REF_NO"   and  " QTY PER CARTON"    columns  and divid by  CELL O36  .


Stanley
FORMAT.xlsm
0
candychan611
Asked:
candychan611
2 Solutions
 
Saqib Husain, SyedEngineerCommented:
=O36/VLOOKUP(O33,MITEM.DBF!$A:$I,9,0)
0
 
theKashyapCommented:
You can use VLOOKUP. E.g.
=O36/VLOOKUP(ma!O33,MITEM.DBF!A1:I1857,9,FALSE)

Param desc:
- ma!O33 = value to be looked up
- MITEM.DBF!A1:I1857 = table in which to lookup the value
- 9 = column number in the lookup table from which the result should be returned ("column I" in you case)
- FALSE = when the lookup table is not sorted you use this.


Attached updated sample. I've updated the formula in cell P46.
FORMAT.xlsm
0
 
candychan611Author Commented:
According to your solution  i've amended the code as follow:

 =IF(O36="","",O36/VLOOKUP(ma!O33,MITEM.DBF!$A$1:$I$3000,9,FALSE))
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now