1=Apple, 2=Car,3=Ship

when I input "1" in A1,then will prompt "Apple" in B2
How to do it, thanks

Hi Winnie,

Use VLookup.

Make a lookup table in the same worksheet or in another. Do it like this:

In cell F1 type 1 and in cell G1 type Apple
In cell F2 type 2 and in cell G2 type Car
In cell F3 type 3 and in cell G3 type Ship

Name the range F1:G3 .... any name. "Thinggies" will do.


Now in Cell B2 type the formula =VLookup(A1,Thinggies,2)

When you input "1" in A1, B2 should find the reference in the table and
display "apple" for you. The number 2 in the above VLookup formula specifies
the column to find the needed data. Follow the same pattern for car and ship.

If you look up "Vlookup" in Excel help it will give you more info about that
function. There is also HLookup which does the same thing at 90 degrees (ie
horizontally instead of vertically)

.... and take enough apples. Sounds like you'll go thru a few on this trip!

LOL Keith




"Winnie" wrote:

1=Apple, 2=Car,3=Ship

when I input "1" in A1,then will prompt "Apple" in B2
How to do it, thanks

Since this is looking for an exact match, I think I'd add that 4th argument:

=VLookup(A1,Thinggies,2,False)



Kevryl wrote:

Hi Winnie,

Use VLookup.

Make a lookup table in the same worksheet or in another. Do it like this:

In cell F1 type 1 and in cell G1 type Apple
In cell F2 type 2 and in cell G2 type Car
In cell F3 type 3 and in cell G3 type Ship

Name the range F1:G3 .... any name. "Thinggies" will do.

Now in Cell B2 type the formula =VLookup(A1,Thinggies,2)

When you input "1" in A1, B2 should find the reference in the table and
display "apple" for you. The number 2 in the above VLookup formula specifies
the column to find the needed data. Follow the same pattern for car and ship.

If you look up "Vlookup" in Excel help it will give you more info about that
function. There is also HLookup which does the same thing at 90 degrees (ie
horizontally instead of vertically)

... and take enough apples. Sounds like you'll go thru a few on this trip!

LOL Keith

"Winnie" wrote:

1=Apple, 2=Car,3=Ship

when I input "1" in A1,then will prompt "Apple" in B2
How to do it, thanks

--

Dave Peterson