Horizontal Search with Multiple Criteria

[march]

Hi All,

I have an export from a provider which I can't change and I need to identify the quantity of an item per customer based on the product line. How would I go about doing that? I was going to use the HLookup but that doesnt work for multiple criteria.

Thanks,

 

[arthurbr]

Please add your XL version to your profile as recent versions have more functions than older ones. Thx

 

[steve the fish]

You can use VLOOKUP and MATCH. You dont say where you have your criteria stored but something like:

=VLOOKUP(F1,$A:$D,MATCH(F2,$A$1:$D$1,0),0)