Vlookup is not working Properly

[dxzaber]

https://drive.google.com/open?id=0B1GJKIl2o1WZYkh1NUhzV0djWUk

please Check my excel from link

why Formula in Cell V28 ,W28 , X28 ,..... is not working????

When only i put .78 in Cell U28 manually then only those formula works..

 

[Ruddles]

I can't see the contents of that sheet.

Common issues with =VLOOKUP include looking up a numeric value in a table where the numbers are stored as text (or vice versa), and displaying numbers to a different number of decimal places and thinking the values are equal when they're actually not when you look at more decimal places.

If you do =U28*1000, do you get 780?

 

[dxzaber]

https://drive.google.com/open?id=0B1GJKIl2o1WZYkh1NUhzV0djWUk

please Check my excel from link

why Formula in Cell V28 ,W28 , X28 ,..... is not working????

When only i put .78 in Cell U28 manually then only those formula works..

how can I share my excel with you???

 

[philaugust2004]

It seems fine to me.
What values were you expecting in V28 etc?

 

[dxzaber]

It seems fine to me.
What values were you expecting in V28 etc?

Does not work with other values. Change .78 to see or change U28 reference to B17

 

[L. Howard]

First off, get rid of the merged cells on your sheet.

The Span Ratio in B17 (from the formula B6/B7) is actually .783783784 and the lookup value in column U is .78.

The formula cell, B17 is formatted as number and the column U cells are formatted as General. I'm not sure that is actually a problem, probably not.

But the actual values do not match.

Howard

 

[mole999]

what is the errant formula

 

[philaugust2004]

try this in B17 and then link U28 back to B17
<bdo dir="ltr">=round(B6/B7,2)</bdo>

 

[MARK858]

For mole999 or anybody else who can't /won't download the file...
The formulas are the ones returning #N/A in the merged cells V28 TO AA29.

Excel Workbook
	U	V	W	X	Y	Z	AA
28	0.81	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
29
30	Ratio (Short/long)	Case-1
31		-' ve		DL '+' ve		LL '+' ve
32		Short	Long	Short	Long	Short	Long
33	1	0.0000	0.0000	0.0360	0.0360	0.0360	0.0360
50	0.83	0.0000	0.0000	0.0524	0.0248	0.0524	0.0248
51	0.82	0.0000	0.0000	0.0536	0.0242	0.0536	0.0242
52	0.81	0.0000	0.0000	0.0548	0.0236	0.0548	0.0236
53	0.8	0.0000	0.0000	0.0560	0.0230	0.0560	0.0230
Sheet1

 

[mole999]

Excel Workbook
	U	V	W	X	Y	Z	AA
28	0.81	0	0	0.0548	0.0236	0.0548	0.0236
29
30	Ratio (Short/long)	Case-1
31		-' ve		DL '+' ve		LL '+' ve
32		Short	Long	Short	Long	Short	Long
33	1	0	0	0.036	0.036	0.036	0.036
50	0.83	0	0	0.0524	0.0248	0.0524	0.0248
51	0.82	0	0	0.0536	0.0242	0.0536	0.0242
52	0.81	0	0	0.0548	0.0236	0.0548	0.0236
53	0.8	0	0	0.056	0.023	0.056	0.023
Sheet1

with U28 in as text, change the formulas (look just after the VLOOKUP, it is two minus signs)