+ Reply to Thread
Results 1 to 4 of 4

Formula need: divide and vlookup combination

  1. #1
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Europe
    MS-Off Ver
    Office 2021 - Win10
    Posts
    1,014

    Formula need: divide and vlookup combination

    Hi experts,
    Do you have any idea why following formula doesnt work?
    Please Login or Register  to view this content.
    Best wishes.
    Sub DontForgetThese()
         If Your thread includes any code Then Please use code tags...
         If Your thread has been solved Then Please mark as solved...
         If Anybody has helped to you Then Please add reputation...
    End Sub

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Microsoft® Excel® for Microsoft 365 MSO (Version 2503 Build 16.0.18604.20000) 64-bit
    Posts
    3,999

    Re: Formula need: divide and vlookup combination

    Which kind of error you are getting???
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  3. #3
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Europe
    MS-Off Ver
    Office 2021 - Win10
    Posts
    1,014

    Re: Formula need: divide and vlookup combination

    Sorrry for disturbing...
    My formula already works.
    Solved.

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Formula need: divide and vlookup combination

    If there is going to be a match for B1 in A, it will be the same as the value of B1 - so you are asking Excel simply to divide C1 by B1. The VLOOKUP is doing nothing.

    Please attach a sample workbook. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    The paperclip icon
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Use combination of IF and Vlookup formula
    By NehaSureka in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-03-2015, 04:23 PM
  2. [SOLVED] Vlookup,Match,Indirect combination formula
    By deepanc in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-27-2013, 07:02 PM
  3. Formula problem - combination of IF and Vlookup
    By Bowish in forum Excel General
    Replies: 1
    Last Post: 05-29-2012, 02:45 AM
  4. SUMIFS and VLOOKUP combination across sheets; dragging formula
    By alillian in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-09-2012, 10:21 AM
  5. Replies: 5
    Last Post: 02-24-2012, 11:20 PM
  6. Help with combination of if and vlookup formula
    By Fbs1960 in forum Excel General
    Replies: 9
    Last Post: 11-19-2011, 10:04 PM
  7. Combination of OFFSET & VLOOKUP formula
    By Polymnia in forum Excel General
    Replies: 7
    Last Post: 08-30-2011, 08:48 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1