Formula Problem

[stephen.smith]

Hey Guys I cant devise a formula to make this work. I have attached an example below. Any help would be appreciated.
Thanks

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Combo Box	Combo Result	Manual Input1	Manual Input 2	Manual Input 3	Max C:E	Table Result			Lookup Table
2		1	1.1	1.1	1.4	1.4	JKL				1	2	3
3		2	1.1	1.8	1.2	1.8	FAU			1.1	ABC	FAD	SAU
4		1	1.2	1.2	1.3	1.3	GHI			1.2	DEF	FAT	SEU
5		3	1.5	1.1	1.3	1.5	SIO			1.3	GHI	FAS	SIU
6		3	1.8	1.2	1.6	1.8	SLP			1.4	JKL	FAR	STU
7		1	1.7	1.1	1.5	1.7	STU			1.5	MNO	FAQ	SIO
8		2	1.4	1.6	1.2	1.6	FAW			1.6	PQR	FAW	SIF
9										1.7	STU	FAY	SOK
10	I cant find a formula to make the table result column work, please help!!									1.8	VWX	FAU	SLP
11
Strength Monitoring

 

[jasonb75]

=vlookup(F2,$J$1:$M$10,B2+1,0)

 

[stephen.smith]

this doesnt work, if i manually type in the answer to the max column it works but when the max formula is finding the result it doesnt work???

 

[jasonb75]

Then the formula result is different to the figure you're typing in.

Check your decimal accuracy with =TEXT(MAX(C2:E2),"0.0000000000")

In F2 =ROUND(MAX(C2:E2),0) will truncate the result and fix the problem.

 

[stephen.smith]

Just checked it, its definitely the same number. I just cant get it to work. there must be something else.??

 

[jasonb75]

What result does the formula give you in G2 with the max formula in F2?

 

[stephen.smith]

#NA

 

[jasonb75]

What cell format are you using on F2:F8 and J3:J10

 

[stephen.smith]

number 0.00 to 2 decimals

 

[jasonb75]

Did you try it with =ROUND(MAX(C2:E2),1) in F2?

Does =vlookup(E2,$J$1:$M$10,B2+1,0) give a result or an error?