Lookup, from multiple occurences, the data corresponding to the bracket within a lookup value falls.

[vanhunk]

I have a table with a list of tank names, with multiple occurrences for each. Each occurrence corresponds to a range where a slope and offset constant is valid.

The challenge is to find the occurence of say 51TK101A from the list under "Tankname" where the

input level, say 6000, falls within the corresponding "Minimum" and "Maximum" bracket,

and then return the corresponding "Slope" and "Offset" values from the table.

 

[Peter Bartholomew]

Could you post the sample workbook rather than having anyone who is willing to reply build their own worksheet from scratch?

 

[vanhunk]

Only a pleasure Peter.

Please find the file for the problem attached.

Regards
vanhunk

 

[Peter Bartholomew]

Somewhat similar to

Extracting record from multiple criteria

Hello Dear Excell Master; May someone assist me how to extracting data record base on multiple criteria. I Found a good youtube channel which seems perfect similar issue i want to formulate, but seems dont work. Here i attach is example book record from youtube sample. I will grateful for...

chandoo.org

= LOOKUP( 2, 1/selected, Data[Slope] )
= LOOKUP( 2, 1/selected, Data[Offset] )

 

[vanhunk]

Thank you Peter, much appreciated!

Best Regards
vanhunk