Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Need help with cells
I need help. I want to be able to type in a numberin cell A1 and the
description to appear on cell B1. Just by typing the number. thank you |
#2
|
|||
|
|||
Look in the Excel help for the Vlookup command. You will need to have a
table of the numbers with their descriptions saved somewhere. "mariflor" wrote in message ... I need help. I want to be able to type in a numberin cell A1 and the description to appear on cell B1. Just by typing the number. thank you |
#3
|
|||
|
|||
I can't seem to get it can you help.
"Lewis Clark" wrote: Look in the Excel help for the Vlookup command. You will need to have a table of the numbers with their descriptions saved somewhere. "mariflor" wrote in message ... I need help. I want to be able to type in a numberin cell A1 and the description to appear on cell B1. Just by typing the number. thank you |
#4
|
|||
|
|||
If you create a list somewhere like this:
Assume this starts in row 10 Col A Col B 1 Blue 2 Green 3 Red Then where you want to look it up, but in Cell B1 =vlookup(a1,a10:b12,2) "mariflor" wrote: I can't seem to get it can you help. "Lewis Clark" wrote: Look in the Excel help for the Vlookup command. You will need to have a table of the numbers with their descriptions saved somewhere. "mariflor" wrote in message ... I need help. I want to be able to type in a numberin cell A1 and the description to appear on cell B1. Just by typing the number. thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
Deselect Cells while using ctrl | Excel Discussion (Misc queries) | |||
Counting only active cells | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |