Forum Discussion
Comparing and getting a result in a column based on another table
- Jan 25, 2022
You broke the vlookup rules
1. You can use Xlookup
2ndly, you should swap the Column that Contains AqX11 to be the first column on the left (except you want to use index and Match
Like this
Original data
COL E | Col F | Col G
After switching it to
ColG | Col E | Col F
Then vlookup will be able to extract the data
Do it now and let me know how it goes
- Aditya JadhavJan 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 you 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.