Thread: Vlookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Robb Robb is offline
external usenet poster
 
Posts: 7
Default Vlookup

I am looking a concatenated value which looks like this "16x16x8" the 8
represents the height of a box and vlookup always seems to go to a shorter
box, so for example it would lookup value 16x16x8 and return 16x16x7.25 I
would like it to return a taller box rather than the shorter box. Is there a
way to this?