View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Henry Hayden Henry Hayden is offline
external usenet poster
 
Posts: 6
Default VLOOKUP using a range variable

Thanks, Tom. I tried this very quickly at work earlier this afternoon
and fo the first time I didn't get a compile- or run-time error. Now I
have to look at the MATCH() function to see how it is applied. I tested
searching for a value that I could clearly see was in the list but it
was not found. I don't yet know what the return values should be. I'll
take a look tomorrow morning and see how it goes. Thanks again- it's
been a long day.


Henry


*** Sent via Developersdex http://www.developersdex.com ***