View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
salgud salgud is offline
external usenet poster
 
Posts: 219
Default Can a vlookup be done on a 2 dimensional array?

On Tue, 11 Nov 2008 18:42:03 -0500, Rick Rothstein wrote:

=TEXT(--("1-"&A1),"m")


Thanks, Rick!