Forum Discussion
Aditya Jadhav
Jan 25, 2022Brass Contributor
Comparing and getting a result in a column based on another table
Dear All, Have been trying to get the output in the file by using Vlookup but it is not working hence need help to complete the task. Have a data set where there are 2 columns which are the top and...
- Jan 25, 2022
Riny_van_Eekelen
Jan 25, 2022Platinum Contributor
Aditya Jadhav I notice you started using PQ but I could not really see what you were doing as you connected to a file on your local system. Tried to replicate what I think you want to achieve. The end result is in columns K:M where column M contains the references to the highest and lowest Aquifier code for that particular range
See attached.
- Aditya JadhavJan 25, 2022Brass Contributor@ Riny_van_Eekelen There is a problem in the returned values in Aqui the resulted values are not complete. Some are missing as the range takes in the resulted first row check that the value is Aq-XIII, Aq-XV but then the Aq-XIV is missing how do we tackle that.
- Riny_van_EekelenJan 25, 2022Platinum Contributor
- Aditya JadhavJan 25, 2022Brass ContributorYes that is it. This is what is needed. If you don't mind can you please guide me step by step how you did this as I'm getting confused with the Sheet. Just cannot relate what all you did to get the final outcome.