If statement with more than one condition

[lborough]

I have a table in columns L, M, N. I am trying to put a formula in column I that says what ever column H is find in column L and display column M in Column I. So in column I the first one would be 0.090, the second would be 0.110, the third would be 0.110 and last would be 0.090.

Col"H"	Col"I"	Col"J"		Col "L"	Col "M"	Col "N"
PP				PP	0.090	0.225
QQ				PQ	0.090	0.275
QT				QQ	0.110	0.275
PQ				QT	0.110	0.325

<COLGROUP><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2596" width=71><COL style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2450" width=67><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2998" width=82><COL style="WIDTH: 48pt" span=3 width=64><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2998" width=82><TBODY>
</TBODY>

 

[mcorriga]

You can use vlookup for this

=VLOOKUP(H1,L:N,2,FALSE)

Paste that down.

 

[circledchicken]

Hi,

Perhaps try VLOOKUP, something like this:

Excel Workbook
	H	I	J	K	L	M	N
1	PP	0.090			PP	0.090	0.225
2	QQ	0.110			PQ	0.090	0.275
3	QT	0.110			QQ	0.110	0.275
4	PQ	0.090			QT	0.110	0.325
Sheet1

Excel 2010

Cell Formulas
Range	Formula
I1	=VLOOKUP(H1,L$1:N$4,2,0)

Note, you can change column index (2) to a 3 for example to get the corresponding data from column N instead.