Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cell Values Formula
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 |
#2
|
|||
|
|||
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 HIS "BubbaJ" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
looking for a formula | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |