VLOOKUP Help

[Puddycat]

In the example below, I want cell AC2 to find the value of cell AL2 in cells AM2 thru AN31 and give me the result from column AN. So in the example AL2 has a value of 7.3. I would expect AC2 to show a result of ALARP.

I thought the formula would be this: =VLOOKUP("AL2",AM2:AN31,2,FALSE) but it is not working. Please keep in mind that cell AL2 is a calculation result from other different cells.

Excel Workbook
	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN
1	*	*	*	*	*	*	*	*	*	*	Risk Factor	Risk Condition
2	#N/A	*	*	*	*	*	*	*	*	7.3	2.1	Acceptable Risk
3	*	*	*	*	*	*	*	*	*	*	3.1	Acceptable Risk
4	*	*	*	*	*	*	*	*	*	*	3.2	Acceptable Risk
5	*	*	*	*	*	*	*	*	*	*	4.1	Acceptable Risk
6	*	*	*	*	*	*	*	*	*	*	4.2	Acceptable Risk
7	*	*	*	*	*	*	*	*	*	*	4.3	Acceptable Risk
8	*	*	*	*	*	*	*	*	*	*	5.1	Acceptable Risk
9	*	*	*	*	*	*	*	*	*	*	5.2	Acceptable Risk
10	*	*	*	*	*	*	*	*	*	*	5.3	ALARP
11	*	*	*	*	*	*	*	*	*	*	5.4	ALARP
12	*	*	*	*	*	*	*	*	*	*	6.1	Acceptable Risk
13	*	*	*	*	*	*	*	*	*	*	6.2	ALARP
14	*	*	*	*	*	*	*	*	*	*	6.3	ALARP
15	*	*	*	*	*	*	*	*	*	*	6.4	ALARP
16	*	*	*	*	*	*	*	*	*	*	6.5	ALARP
17	*	*	*	*	*	*	*	*	*	*	7.1	ALARP
18	*	*	*	*	*	*	*	*	*	*	7.2	ALARP
19	*	*	*	*	*	*	*	*	*	*	7.3	ALARP
20	*	*	*	*	*	*	*	*	*	*	7.4	Intolerable Risk
21	*	*	*	*	*	*	*	*	*	*	7.5	Intolerable Risk
22	*	*	*	*	*	*	*	*	*	*	8.2	Intolerable Risk
23	*	*	*	*	*	*	*	*	*	*	8.3	Intolerable Risk
24	*	*	*	*	*	*	*	*	*	*	8.4	Intolerable Risk
25	*	*	*	*	*	*	*	*	*	*	8.5	Intolerable Risk
26	*	*	*	*	*	*	*	*	*	*	9.3	Intolerable Risk
27	*	*	*	*	*	*	*	*	*	*	9.4	Intolerable Risk
28	*	*	*	*	*	*	*	*	*	*	9.5	Intolerable Risk
29	*	*	*	*	*	*	*	*	*	*	10.4	Intolerable Risk
30	*	*	*	*	*	*	*	*	*	*	10.5	Intolerable Risk
31	*	*	*	*	*	*	*	*	*	*	11.5	Intolerable Risk
Sheet

 

[pgc01]

Hi

Try:

=VLOOKUP(AL2,AM2:AN31,2,FALSE)

 

[Puddycat]

Thanks. That worked. Now how do I copy that formula to all of the other cells in column AC but make sure that it keeps referencing cells AM2 thru AN31?

 

[Access Beginner]

I no expert and my guess you would just use absolute references in the formula

=VLOOKUP(AL2,$AM$2:$AN$31,2,FALSE)

Not sure if that's what your after.

 

[Smitty]

Not sure if that's what your after.

Sounds like it.

Check out Absolute and Relative References in the helpfile; it explains the significance of the $'s.