View Single Post
  #1  
Old May 16th, 2009, 09:38 PM posted to microsoft.public.excel.misc
M Thompson
external usenet poster
 
Posts: 38
Default Why does this work?

I got this formula from Max, Singapo =VLOOKUP((A1&B1)+0,Sheet2!A1:C6,3,0)
I would like to know how the +0 is working in this. I've spent about alot of
time in Help and on the internet trying to find out, but I think you guys are
the ones that can clear it up. I know it's making the formala recognize the
concatenation as a number, but how?
Thanks and have...
--
OneFineDay