Why does this work?
Just to add to Dave's reply, any mathematical operation on a piece of text
that can be interpreted as numeric, will coerce it to a numeric.
Same answer can be obtained with:
=VLOOKUP((A1&B1)+0,Sheet2!A1:C6,3,0)
=VLOOKUP((A1&B1)*1,Sheet2!A1:C6,3,0)
=VLOOKUP(--(A1&B1),Sheet2!A1:C6,3,0)
Regards
Ken..................
"M Thompson" wrote in message
...
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
|