pull down to refresh
21 sats \ 1 reply \ @SimpleStacker 16 Dec \ on: I need an Excel formula devs
(deleted) I didn't see the requirement to look up ID as well. Will return with another post.
Sorry is incomplete.
I think I forgot to add something.
The ID column is filled with many numbers so the formula also have to find the one corresponding to D3 number ID in the column A (I put the same number to see where should come the data).
So some other VLOOKUP should be added.
| ID | Service | Data | ||||||
|---|---|---|---|---|---|---|---|---|
| 1234 | AAA | 4032 | AAA | BBB | CCC | DDD | EEE | |
| 1234 | BBB | 145 | 1234 | vlookup or IF ? | vlookup or IF ? | vlookup or IF ? | vlookup or IF ? | vlookup or IF ? |
| 1234 | CCC | 136,5 | 456 | |||||
| 1234 | DDD | 48 | 658 | |||||
| 1234 | EEE | 56 | ||||||
| 456 | ||||||||
| 456 | ||||||||
| 658 | ||||||||
| 658 |
reply