| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying cell range with 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 "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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying cell range with Vlookup
Can do, but how would I change the vlookup to only count how many rows that
it finds the specfic lookup? "Bernie Deitrick" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - copy absolute cell references (within the range) as relati | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Displaying value of specific cell within a range, with IF function...? | Excel Discussion (Misc queries) | |||
| Vlookup did cell auto formating but not displaying complete text.. | Excel Worksheet Functions | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Linear Mode
