VLOOKUP using hidden/filtered data

MikeSp

New Member
Joined
Oct 30, 2019
Messages
2
I have a list of prices, products, customers, etc. that are in categories (Beef, Chicken, etc.) and in subsets (Salisbury, Ground, Raw, etc.).

I am using the Aggregate function to determine the lowest price.
Then, I use the VLOOKUP function to search that lowest price for who is purchasing and other data.
I'm having some issues when I Filter down to a category (or in some cases, multiple categories to drill down) when that same "lowest price" is in multiple categories).
VLOOKUP is capturing data from the hidden/Filtered rows.

I need VLOOKUP to ignore hidden/Filtered rows.

TIA

Mike
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Watch MrExcel Video

Forum statistics

Threads
1,095,779
Messages
5,446,460
Members
405,403
Latest member
horace james

This Week's Hot Topics

Top