use vlookup with offset function
G1: holds drop down menu
=INDEX(E1:E7,MAX((A1:A7=G1)*(ROW(A1:A7))))
ctrl+shift+enter, not just enter
"liem" wrote:
I have a drop down menu when I selected a item (merchandise...) I want to
return three row and four columns (B to e)
drop down menu merchandise
Gasoline
Food
A B c d e
merchandise john robert 500 40 4 .2%
merchandise jeff gordon 800 90 4.5%
merchandise julia robel 1000 90 6.5%
gasoline mak dune 50 34 3,2%
gasoline nancy thom 90 37 8.1%
gasoline john good 200 34 5.4%
food john 19 11 4.4%
what is the formula when I used vlookup(merchandise ...)
--
thanks
|