On 2002-04-12 08:52, Brian from Maui wrote:
On 2002-04-12 08:40, ubiqman wrote:
Maybe I can clarify better, If I have ten items that correspond to ten different items, how can I type one in any column and get the correspoding output.
Ex...
I have five items...
tree = green
car = blue
house = red
dog = black
fish = orange
How can I make it so when I type any of the five inputs in any column, I get the corresponding answer.. Can I do that...? SOrry if this sounds confusing.. I am new to the formulas... Thanks!!!
Try VLOOKUP
Column A
tree
car
house
dog
fish
Column B
green
blue
red
black
orange
In any cell other than A1:B5
try
=vlookup(c1,A1:b5,2)
Where C1 is the cell you type in dog etc.
Also, try a named formula :
Try this : it needs setting up just the once :
select cell B1
insert (from the toolbar)
names
define
where it's blinking, name it something short and appropriate, like UBQ1 or something
in "refers to" type the following :
=VLOOKUP(!A1,{"chicken","duck";"tree","green";"car","blue";"house","red";"dog","black";"fish","orange"},2,0)
click on "add"
click on "ok" to exit
now, in any cell on any sheet, enter =UBQ1 next to your chicken/tree/car/house/dog entry
and you'll get duck/green/blue/red/black returned
Hopefully, also, some VBA expert will spot this post and offer an even easier way, without the need to double-enter...