Lookup not returning proper value

[xcel50]

Hello, can some explain to me why my lookup is not working properly the table is set as

C2 has the word INF
D2 =LOOKUP(C2,F1:F4,G1:G4) 'with the word INF the result is 4 but any other word does display the correct number
F1 has the word CRI
F2 has the word MAJ
F3 has the word MIN
F4 has the word INF

G1 has the word 4
G2 has the word 3
G3 has the word 2
G4 has the word 1

Sorry guys I wish I could upload the actual sheet

 

[AhoyNC]

To use LOOKUP your data must be sorted in ascending order.
Try using VLOOKUP instead.

=VLOOKUP(C2,F1:G4,2,0)

 

[xcel50]

To use LOOKUP your data must be sorted in ascending order.
Try using VLOOKUP instead.

=VLOOKUP(C2,F1:G4,2,0)

No matter what in which order I sort them it doesn't work, at the end I went with the vlookup, thanks

 

[AhoyNC]

You're welcome. When I sorted your column F in ascending order the LOOKUP seems to work.

Excel Workbook
	C	D	E	F	G
1				CRI	4
2	INF	1		INF	1
3				MAJ	3
4				MIN	2
Sheet

 

[xcel50]

You're welcome. When I sorted your column F in ascending order the LOOKUP seems to work.

	C	D	E	F	G
			CRI
INF		INF
			MAJ
			MIN

<colgroup><col style="width:30px; "><col style="width:64px;"><col style="width:64px;"><col style="width:69px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]

[TD="align: right"]4[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]

[TD="bgcolor: #ffff00, align: right"]1[/TD]

[TD="align: right"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]

[TD="align: right"]3[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]

[TD="align: right"]2[/TD]

</tbody>

Spreadsheet Formulas

Cell Formula D2 =LOOKUP(C2,F1:F4,G1:G4) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

Ok, you went alphabetical, I was sorting by the number only or by the level of the alarm so critical, major, minor and informational or informational, minor, major and critical, now I feel so silly . I will still use the vlookup as I need to keep the order as my ordinal post, but thanks for the info