Re: Cell Values Formula

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Nick Hodge (nick_hodgeTAKETHISOUT_at_zen.co.uk.ANDTHIS)
Date: 01/30/05 

Date: Sun, 30 Jan 2005 23:40:07 -0000

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
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
"BubbaJ" <BubbaJ@discussions.microsoft.com> wrote in message 
news:FCAD1094-8D73-403E-B6EC-6D40EAABB832@microsoft.com...
> Hi
>
> I am trying to create a work*** 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
Quantcast