hi,
do you know how to perform nested Index Match in Power Query?
Start looking in 1st column, then narrow looking in 2nd column, and then give a result from the 3th column. For example 11 gives aaa and 4B gives fff.
One more thing, can I make it without merging columns 1 and 2?
No Index Description 1 1 aaa 1 2 bbb 2 R ccc 3 1 ddd 4 A eee 4 B fff
Bookmarks