1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL

  • Re: vlookup as percentage of another vlookup

    From Ammammata@21:1/5 to All on Wed Dec 1 08:13:16 2021
    Il giorno Wed 01 Dec 2021 08:37:01a, *PaddyStan* ha inviato su microsoft.public.excel il messaggio news:[email protected]. Vediamo
    cosa ha scritto:

    I wish to put a vlookup formula in two adjacent cells, lookup up two different values.

    I want the second vlookup cell to return its value as a percentage of
    the first vlookup cell value without having to add an extra column or
    cell.

    Please advise.


    "In che senso?"
    (cit. Verdone: https://www.youtube.com/watch?v=U9Kq95CQfF8)

    Please provide an example

    --
    /-\ /\/\ /\/\ /-\ /\/\ /\/\ /-\ T /-\
    -=- -=- -=- -=- -=- -=- -=- -=- - -=-
    ........... [ al lavoro ] ...........

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From PaddyStan@21:1/5 to All on Tue Nov 30 23:37:01 2021
    I wish to put a vlookup formula in two adjacent cells, lookup up two different values.

    I want the second vlookup cell to return its value as a percentage of the first vlookup cell value without having to add an extra column or cell.

    Please advise.

    Thanks

    PaddyStan

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From PaddyStan@21:1/5 to Ammammata on Thu Dec 2 21:23:56 2021
    On Wednesday, December 1, 2021 at 7:13:21 PM UTC+11, Ammammata wrote:
    Il giorno Wed 01 Dec 2021 08:37:01a, *PaddyStan* ha inviato su microsoft.public.excel il messaggio

    cosa ha scritto:
    I wish to put a vlookup formula in two adjacent cells, lookup up two different values.

    I want the second vlookup cell to return its value as a percentage of
    the first vlookup cell value without having to add an extra column or
    cell.

    Please advise.

    "In che senso?"
    (cit. Verdone: https://www.youtube.com/watch?v=U9Kq95CQfF8)

    Please provide an example

    --
    /-\ /\/\ /\/\ /-\ /\/\ /\/\ /-\ T /-\
    -=- -=- -=- -=- -=- -=- -=- -=- - -=-
    ........... [ al lavoro ] ...........
    Ammammata

    I can't seem to supply you with a screenshot, however I think I've worked it out.

    =VLOOKUP(O7,'Sheet1'!B:BT,71,FALSE)/=VLOOKUP(O7,'Sheet1'!B:BL,63,FALSE), and then re-format the cell as a percentage to two decimal places.

    Many thanks for your offer of help.

    Kindest regards

    PaddyStan

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Ammammata@21:1/5 to All on Fri Dec 3 07:33:27 2021
    Il giorno Fri 03 Dec 2021 06:23:56a, *PaddyStan* ha inviato su microsoft.public.excel il messaggio news:[email protected]. Vediamo
    cosa ha scritto:

    I can't seem to supply you with a screenshot, however I think I've
    worked it out.

    =VLOOKUP(O7,'Sheet1'!B:BT,71,FALSE)/=VLOOKUP(O7,'Sheet1'!B:BL,63,FALSE)
    --------------------------------------^

    this EQUAL operator seems wrong

    , and then re-format the cell as a percentage to two decimal places.




    --
    /-\ /\/\ /\/\ /-\ /\/\ /\/\ /-\ T /-\
    -=- -=- -=- -=- -=- -=- -=- -=- - -=-
    ........... [ al lavoro ] ...........

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)