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
Aditya Jadhav
Jan 25, 2022Brass Contributor
Just tried the Vlookup formula as you suggested and have attached the sheet please do tell if I'm doing it wrong.
Donald_Genes_
Jan 25, 2022Brass Contributor
Question is,
What lookup value are yo
u looking for
Table_array - where can I find them
Column index - what column number should I return
False
Now,I your case you are looking for A2 which is a number
Of course Vlookup would return NOt Available because there was no matching value
I am using Excel mobile app to check your function..
So the me what exactly you are looking for again?
Anyways let me turn on my laptop and do it for you
- Aditya JadhavJan 25, 2022Brass ContributorNow the Column A and B is the range which should compare it with the Column F and G and return the Value of Column E in to the Column C.
In short the range of top and bottom should match and return the text from Column Aquifer to the matching rows and fill it across the data.