Lookup Index #NA Help!!!

[stephen.smith]

Hi Guys I am having a huge problem with a complicated index and lookup formula. How do I paste in an example into one of these messages so I can show you guys the problem.
Thanks
Stephen

 

[hiker95]

stephen.smith,

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										1.8	VWX	FAU	SLP
11
71

 

[hiker95]

stephen.smith,

FYI - the above screenshot is what I got the other day from your original post???