Cell Values Formula

B

BubbaJ

Hi

I am trying to create a worksheet whereby when i enter certain data, e.g.
the letter 'D', it returns a pre set value etc and the same for the rest of
the alphabet, any advice would be gratefully accepted x
 
N

Nick Hodge

Set up a table with A-Z in one column, say A and the values in column B then
use this as a VLOOKUP table, thus (Entered in D1)

=VLOOKUP(C1,$A$1:$B$26,2,FALSE)

You then enter a letter in C1 and the value will appear in D1

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
Top