View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Christobee
 
Posts: n/a
Default lookup to return larger value

It works. Very helpful. Thanks Grove!

"Harlan Grove" wrote:

Christobee wrote...
I get and Error message with both of your formulas for some reason the
formulas contain invalid data

....

Did you enter the *ARRAY* formulas as *ARRAY* formulas, meaning holding
down [Ctrl] and [Shift] keys before pressing [Enter]?