Is there anyway to search a table indexing on a column that is to the left of
the column I am indexing on?

e.g. I want to find the Number (in case being 1) that is associated with
"A" in this table:

1 A
2 B
3 C