Danhalawi,

Don't use merged cells, or use another column with un-merged cells, with the value in every cell
where it applies. Then use Data Autofilter on that column to show the value that you want to
display.

HTH,
Bernie
MS Excel MVP


"Danhalawi" wrote in message
...
Can someone help?

I want to display in cell the range of a table array after finding it with
VLOOKUP.
I have a table with merge cell down one side of the table to represent the
group of a list of products.
I.E in column A is a list of product groups... breakfast, lunch, dinner and
so on...

What I want to do is once the vlookup finds a specific product to display
what the table area it covers

=vlookup(C6,'All SHOPS'!A2:A236,,)

Please help.
This is my current vlookup