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

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Watch MrExcel Video

Forum statistics

Threads
1,095,422
Messages
5,444,355
Members
405,278
Latest member
karen1

This Week's Hot Topics

Top