how do i combined if with v lookup

[Henry_Falcon77]

Hello All. I have 3 countries. Japan, USA, and China for example. EAch of those countries have certain limits. Japan would have 5k, USA would have 10k and china would have 20k. I would like to create a formula that if it displayed a certain country with amount, then it would read over the limit or under the limit. If my Japan total was 6k, I would like it read over the limit. If my USA total was 9k. I would like it to read under the limit. Thanks in advance.

 

[ExceLoki]

try this:
----------------

Book1
	A	B	C	D	E
1	Japan	5000		country	USA
2	USA	10000		limit	9000
3	China	20000		over/under	under
Sheet1

Cell Formulas
Range	Formula
E3	E3	=IF(VLOOKUP(E1,A1:B3,2,FALSE)<E2,"over","under")

Cells with Data Validation
Cell	Allow	Criteria
E1	List	=$A$1:$A$3

 

[Henry_Falcon77]

try this:
----------------

Book1
	A	B	C	D	E
1	Japan	5000		country	USA
2	USA	10000		limit	9000
3	China	20000		over/under	under
Sheet1

Cell Formulas
Range	Formula
E3	E3	=IF(VLOOKUP(E1,A1:B3,2,FALSE)<E2,"over","under")

Cells with Data Validation
Cell	Allow	Criteria
E1	List	=$A$1:$A$3

That was beyond helpful. You saved me lots of time. In my excel sheets, column G and H are given and I was going to put the formula in column I. Do I have to keep on changing the first line of my formula with the $ symbol as in $A$2:$B$33 or is there a way I can lock all my data in columns A and B with $. For now, I am just changing my first line (I2 ) with the additional $ signs and then dragging down. . In the future, I plan to have my data in A and B on separate worksheet and just use it as a reference.

try this:
----------------

Book1
	A	B	C	D	E
1	Japan	5000		country	USA
2	USA	10000		limit	9000
3	China	20000		over/under	under
Sheet1

Cell Formulas
Range	Formula
E3	E3	=IF(VLOOKUP(E1,A1:B3,2,FALSE)<E2,"over","under")

Cells with Data Validation
Cell	Allow	Criteria
E1	List	=$A$1:$A$3