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