return only available data

**Queenie Balb** · 10-20-2015, 04:23 AM

Hi guys,
I have detected an unforeseen problem. Please open the file MOCK UP JOURNEY PLAN and look at the cells colored in yellow.

In tab Journey Plan, I need to return the top 5 products in range H19:L23.
This info is in tab Categ, range Q:U.
The formula works alright, but when I come to Polynesian spa, it only has 3 products. These 3 products are returned into tab Journey Plan range H19, H20 and H21. However, on H22 and H23, the formula picks up the products from the following Spa (Champs Elisees).
I need the range H22:H23 to show blank.
Anyway, I thought this would easy to fix because these fields are driven by cell B1, but I am having trouble with this.
Can you please help? The file is attached.
Thanks a lot.
Attached Files Attached Files

**hosna** · 10-20-2015, 04:34 AM

Hi
you can change your formula like this:

Please Login or Register  to view this content.

in this way you compare number of salon name in the database with number of salon name in Journey plan sheet.

**Queenie Balb** · 10-20-2015, 05:22 AM

Thank you Hosna. Your solution was brilliant!

return only available data

LinkBack

Thread Tools

Rate This Thread

Display

return only available data

Re: return only available data

Re: return only available data

Thread Information

Users Browsing this Thread

Similar Threads

Find data based off unique identifiers and return only columns showing data

Double click row to return data to userform for edit then return back to sheet

[SOLVED] SUMIF - If there is no value to return, return "NO DATA TO DISPLAY"

[SOLVED] Data Validation --> Return Multiple Values via VLookup from Dynamic Data

Excel 2007 : Search data. If found, return data and color original cell background

Changing VBA code to return data range, appending to prior data

Index Row and return data in a Single Column:No return

Bookmarks

Bookmarks

Posting Permissions