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

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Watch MrExcel Video

Forum statistics

Threads
1,090,384
Messages
5,414,133
Members
403,515
Latest member
see_mido

This Week's Hot Topics

Top