VLOOKUP using hidden/filtered data

[MikeSp]

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

 

[James006]

Hi,

You could take a look at following thread :

https://www.mrexcel.com/forum/excel-questions/519219-vlookup-using-visible-cells-only.html

Hope this will help

 

[MikeSp]

I got it working....I think! Thank you!

 

[James006]

Glad you could fix your problem