vlookup to return 2 columns
You're welcome. Thanks for the feedback!
Biff
"oldLearner57" wrote in message
...
hi T. Valko :) thanks it works well :)
the 2nd formula works fine, need to absolute the lookup range
much appreciated :)
thanks again
thanks community
--
oldLearner57
"T. Valko" wrote:
You need 2 formulas in 2 cells.
Actually, you can enter 1 formula in 1 cell and then just drag copy
across
to the other cell.
Try this:
=VLOOKUP(lookup_value,$A$1:$C$3,COLUMNS($A:B),0)
Now just drag copy across to the other cell.
If the lookup_value is a reference to a cell make at least the column
reference absolute:
H1 = lookup_value
=VLOOKUP($H1,$A$1:$C$3,COLUMNS($A:B),0)
Biff
"oldLearner57" wrote in message
...
hi
can use vlookup function to return with 2 columns value ?
example:
A B C
1 H Home $200
2 C Car $100
3 B Boat $250
by using the above range, i know how to use the vlookup to return, say,
A1,
it return for me "Home"...(i.e: =vlookup(lookupValue,A1:C3,2)
how can i use the lookup to return more than 1 data, example, base on
the
above, I want it to display for me "Home" and "$200", and have them
place
in
separated cell?
any help community ?
thanks community :)
--
oldLearner57
|