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: | 296 |
Nodes: | 16 (2 / 14) |
Uptime: | 73:18:04 |
Calls: | 6,657 |
Calls today: | 3 |
Files: | 12,203 |
Messages: | 5,332,384 |
Posted today: | 1 |