View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Finding the corresponding value in a range?

Zuo, ask your new query in a fresh thread if Duke did not respond further in
that thread. Here, does my solution address ALL of your specs which you asked
in your original posting here? If so, take a moment, close it off, hit the
YES in that earlier response. Thanks.
--
Max
Singapore
---
"Zuo" wrote:
Max,

Thanks for your very detailed answer, very professional! I have a question
though, Duke had proposed the following solution which seems simpler but had
a problem which I could not resolve, see below. Is this a better solution
for the first part of the table? If so, how do I resolve the problem with
his formula?