If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|