Formula

[Johnboy28]

Can someone help with a formula - Need to lookup (Match)"PLU no" from table, if "max weight" is above table then it will return Red, and if max weight is below then return Green.. First result is Red as its over 0.900 Weight.

Table​
PLU no	Max Weight
1	0.900
10	0.530
12	0.525
14	1.042
20	0.430
PLU no	Max Weight	Results
1	1.2600	Red
10	0.2500
12	0.3440
14	0.2862

 

[Eric W]

Try:

Book1
	A	B	C
1	Table
2	PLU no	Max Weight
3	1	0.9
4	10	0.53
5	12	0.525
6	14	1.042
7	20	0.43
8
9	PLU no	Max Weight	Results
10	1	1.26	Red
11	10	0.25	Green
12	12	0.344	Green
13	14	0.2862	Green
14	20	0.75	Red
Sheet5

Cell Formulas
Range	Formula
C10:C14	C10	=IF(B10>VLOOKUP(A10,$A$3:$B$7,2,0),"Red","Green")

 

[Johnboy28]

=IF(B10>VLOOKUP(A10,$A$3:$B$7,2,0),"Red","Green")

Great - Thank you