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.
Il giorno Wed 01 Dec 2021 08:37:01a, *PaddyStan* ha inviato su microsoft.public.excel il messaggioAmmammata
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 ] ...........
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.
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 490 |
Nodes: | 16 (1 / 15) |
Uptime: | 70:40:21 |
Calls: | 9,678 |
Calls today: | 2 |
Files: | 13,722 |
Messages: | 6,172,206 |