Hi All,
I am having some problems with my VLOOKUP function and cannot seem to figure out what is going wrong.
My excel formula looks a bit like this:
=VLOOKUP (D1, A1:B151,2,FALSE)
The lookup value in cell D1 = 2
I am trying to search column A for the value of "2" and have it return the corresponding value in column B.
Column A contains values from 1.5 to 3 in increments of 0.01 (1.5, 1.51 etc)
Column B contains values from -2 to -0.8 in increments of 0.008 (eg, -2.0, -1.992 etc)
I am encountering a few problems such as:
- If my lookup value is between 1.5 and 1.63 the function works perfectly, but if I pick a higher lookup value (for example 2) it returns #N/A
- If I use TRUE instead of FALSE at the end of my function I will get an approximate match with any look up value I type in between 1.5 and 3. I find this odd as putting "FALSE" at the end of my VLOOKUP will not work for values greater than 1.63?
The values in columns A and B are formulas. I have tried to copy and paste these values separately but I still get the same #N/A problem occurring when I try to search for specific values.
I've also tried making sure all the cells have the same format (general or number etc). Even used the TRIM tool to try and get rid of any invisible spaces that might be there.
Any help would be greatly appreciated as I am definitely stuck going in circles with this one haha
Thanks
I am having some problems with my VLOOKUP function and cannot seem to figure out what is going wrong.
My excel formula looks a bit like this:
=VLOOKUP (D1, A1:B151,2,FALSE)
The lookup value in cell D1 = 2
I am trying to search column A for the value of "2" and have it return the corresponding value in column B.
Column A contains values from 1.5 to 3 in increments of 0.01 (1.5, 1.51 etc)
Column B contains values from -2 to -0.8 in increments of 0.008 (eg, -2.0, -1.992 etc)
I am encountering a few problems such as:
- If my lookup value is between 1.5 and 1.63 the function works perfectly, but if I pick a higher lookup value (for example 2) it returns #N/A
- If I use TRUE instead of FALSE at the end of my function I will get an approximate match with any look up value I type in between 1.5 and 3. I find this odd as putting "FALSE" at the end of my VLOOKUP will not work for values greater than 1.63?
The values in columns A and B are formulas. I have tried to copy and paste these values separately but I still get the same #N/A problem occurring when I try to search for specific values.
I've also tried making sure all the cells have the same format (general or number etc). Even used the TRIM tool to try and get rid of any invisible spaces that might be there.
Any help would be greatly appreciated as I am definitely stuck going in circles with this one haha
Thanks