View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Danhalawi Danhalawi is offline
external usenet poster
 
Posts: 4
Default Displaying cell range with Vlookup

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