G
Guest
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
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