Excel Vlookup when first vlookup is balnk

Joined
Oct 8, 2017
Messages
1
Reaction score
0
hello,
ID1 ID2 Comment

4587 Magic
4588 DWS Magic

Any ideas how to write a formula to return the DWS ID2 for ID1 4587 based on the same comment?
Thanks a mil
 
Back
Top