I am preparing a new spreadsheet to record advertising sales bookings. There
are different sized advertisements and rates vary between clients. Each
client is listed in one column with the prices for each size advertisement in
the same row. On from this are columns for bookings to be recorded in each
edition for example:

Client Q H F AUG SEPT OCT NOV DEC
a 200 500 800
b 150 450 650

Can I use a formula to create a way of typing e.g. "H" in the cell below the
appropriate month, corresponsding to a particular client, say "b", and pull
through rate quoted?

Any help really would be appreciated.