Dear Frank,

Sorry to reply late. The web can't be shown properly in my laptop for days.

My purpose is to show two cells at the same time(in my case, show '10' and
'red' side by side as a result). Your answer really helps me.

Thanks and best wishes.
jiang

"Frank Kabel" wrote:

Hi
do you mean
=VLOOKUP(10,A1:B20,2,0)

"jiang" wrote:

Frank, thanks for your prompt reply.

It's really a pity to realize this point.

Now I'm make a new table, like
A B C D (Column)
1, 10 red, 20 blue
2, 15 red, 10 yellow
(Row)
Is it possible to use lookup, vlookup, or hlookup to show result like:
10 red
10 yellow
If I search 10 in the above table?

Thanks.