# If statement with more than one condition

#### lborough

##### New Member
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>

### Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

#### mcorriga

##### New Member
You can use vlookup for this

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

Paste that down.

#### circledchicken

##### Well-known Member
Hi,

Perhaps try VLOOKUP, something like this:
Excel Workbook
HIJKLMN
1PP0.090PP0.0900.225
2QQ0.110PQ0.0900.275
3QT0.110QQ0.1100.275
4PQ0.090QT0.1100.325
Sheet1
Excel 2010
Cell Formulas
RangeFormula
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.

Replies
10
Views
1K
Replies
1
Views
258
Replies
1
Views
600
Replies
1
Views
287
Replies
7
Views
752

### Forum statistics

1,129,685
Messages
5,637,808
Members
416,983
Latest member
LessThanAverageUser

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back