Ok, glad you got it working!

--
Biff
Microsoft Excel MVP


"liem" wrote in message
...
I am sorry on the combo box question. my combo box only have source of the
name description data only and i set the range of in the property. such as
Merchandise,Gasoline,merchandise GP,...etc

I re type the formual again I made a mistake of type in your formula and i
tried again. it working as it should.

thanks you very much for your help

liem pho



--
thanks


"T. Valko" wrote:

You're not following me in what I'm asking.

See this screencap:

http://img158.imageshack.us/img158/5...controlts7.jpg

When you created the combo box you had to enter a source for the items in
the combo box. The source is entered in the box labled Input range
(highlighted in yellow). What did you enter as the Input range? You have
to
match the linked cell to an item in the input range. This will tell the
lookup formula what data you want to find.

--
Biff
Microsoft Excel MVP


"liem" wrote in message
...
The source of comb box depend on the user what they want to see.
I have merchandise, gasoline for food as the factors in the comb box.
If the user selected "merchandise" in the comb box. how can I get all
three
row back at the same time ( B1 to E3) .
john robert 500 40 4 .2%
jeff gordon 800 90 4.5%
julia robel 1000 90 6.5%

or if the user selected Gasoline, i like to have the data back from (
B4:
to
E6)

mak dune 50 34 3,2%
nancy thom 90 37 8.1%
John good 200 34 5.4%

or if the user selected Food the result only back on one row b7:e7

john Robert 19 11 4.4%

i hope you can show me the way to get these data back depend on the
user
select in the comb box. the comb box point to row a4 and the result
show
up
in row a5.

--
thanks


"T. Valko" wrote:

Ok, so what is the source for the combo box?

You have to match the value of the linked cell to the source in order
to
tell the lookup formula where to look for the data you want. For
example:

Suppose you have these selections in your combo box:

merchandise
gasoline
food

If you select food the linked cell returns the value 3 because food is
the
3rd item in the list. If you select merchandise the linked cells value
is
1
because merchandise is the 1st item in the list. So, you have tell the
lookup formula what the number in the linked cell represents.

--
Biff
Microsoft Excel MVP


"liem" wrote in message
...
yes, combo box have link cell b4.
--
thanks


"T. Valko" wrote:

Ok, a combo box makes it a little bit more complicated.

Do you have the combo box linked to a cell? The linked cell will
return
the
*number* of the selected item. What's the location of the source
for
the
combo box?

--
Biff
Microsoft Excel MVP


"liem" wrote in message
...
Thank you for all response, but I am sorry I did not made clear
on
the
drop
down from the question last night i asked.
The drop down i have in the worksheet is the comb box macro.
if the user selected "Merchandise" or "Food" then I like the
result
of
all the merchandise show up in this case from column b2:e3 .
Or if the user selected "Food" on the drop down then the result
should
be
b7:e7
the data on one worksheet and the comb box in other worksheet.

how can I used lookup function with Offset function in this
case?
or a better way to get the result

thanks

liem


--
thanks


"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 Robert 19 11 4.4%

what is the formula when I used vlookup(merchandise ...)
--
thanks