Displaying cell range with Vlookup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Can do, but how would I change the vlookup to only count how many rows that
it finds the specfic lookup?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Vlookup Help 0
vlookup range 4
Vlookup with a pick list for tables 1
vlookup table_array 4
VBA userform Vlookup Excel 1
how do i use the text in a cell as a named range in a vlookup form 2
vlookup not working properly 5
Multiple VLOOKUPS 4

Back
Top