It is either

=VLOOKUP(200,A:F,5,FALSE)
(5 being the 5th column in the range)

or

=HLOOKUP("Orange",1:4,3,FALSE)
(3 being the 3rd row in the range)

"Kevin W" wrote:

Hi,

I probably have 30 or so columns and 200 rows. For simplicity if I have:

A B C D E F
1 Blue Green Red Orange Purple
2 100 2 4 6 3 5
3 200 8 9 5 7 2
4 300 5 8 1 3 2

The names of the columns are colors and the names of the rows are numbers
(and they are all known beforehand).

What formula do I need to retrieve the value of the cell that corresponds to
Orange and 200 (so I want to retrieve the number 7)?

Thanks!