Thread: HLOOKUP
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ray Ray is offline
external usenet poster
 
Posts: 267
Default HLOOKUP

What do you mean by "doesn't work"? Do you get an error message or
the wrong result or ???

If you're getting an #N/A error, there's probably a formatting issue
in play -- for example, N7 is Text, while N9:P9 are Numbers ...