Forum Discussion
Getting a value from two different columns
Aditya Jadhav Can see what you want to achieve though I see a slight problem. Your Geology list has 17 different ranges for code RL. To overcome that I renamed them to RL01 to RL17. Then I played around a bit with Power Query, without attempting to optimize the process. Ultimately, it gives you the Geo-codes for the lowest and highest values in the range. Perhaps this will help you in the other Geo-codes that fall between these two.
See attached.
For the manual thing have attached a sheet which has the logic and details written in it.
Aditya Jadhav Can see what you want to achieve though I see a slight problem. Your Geology list has 17 different ranges for code RL. To overcome that I renamed them to RL01 to RL17. Then I played around a bit with Power Query, without attempting to optimize the process. Ultimately, it gives you the Geo-codes for the lowest and highest values in the range. Perhaps this will help you in the other Geo-codes that fall between these two.
See attached.
- Dear Riny_van_Eekelen this works like a charm will try this out for the rest of the workbook.
Thanks a lot.Have another problem now but the thing is that did not understand all the steps in power query to get the output. Would be helpful if you could guide me step by step so then that can be cleared entirely. attaching the file for ready reference.
Thanks in advance.
Aditya Jadhav Better to open a new thread describing your problem, what file represents, what you need to do with it. And most importantly, what the end result should look like.