Based on the posted sample data:

=SUMPRODUCT((A3:C11=A15)*D3:D11)

--
Biff
Microsoft Excel MVP


"Lars-Åke Aspelin" wrote in message
...
Your formula does not fly Stephen.

Lars-Åke


On Fri, 25 Jul 2008 10:07:01 -0700, Stephen Lloyd
wrote:

To use Vlookup you'll need to extend your first column to include the
whole
alphabet a-z and repeat the numbers in the second column. Vlookup can
only
search a single column.

If the layout you show needs to stay as is you could do the following:

Lets say you're typing a letter into cell A15 and want B15 to display the
associated number value. In b15 write...

=sumproduct(--(a3:a11=A15),--(b3:b11=a15),--(c3:c11=a15),D3:d11)



"MagicBill" wrote:

I am trying to return a number (1-9) for a letter.

For instance:

A B C D

A J S 1
B K T 2
C L U 3
D M V 4
E N W 5
F O X 6
G P Y 7
H Q Z 8
I R 9

I can do the first column, but when I try the second or third columns, I
get
an error value. So how can I type in a W and get it to return a 5, an I
to
return a 9, and so on?