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
|