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.
|