VLOOKUP giving bizarre results

[M0X3]

In a certain column I have the formula "=IFERROR(VLOOKUP(cell1,range1,2)+0,IFERROR(VLOOKUP(cell2,range2,15)+0,0)"
The first part of the formula works fine. I get the expected results returned to me. The second part "VLOOKUP(cell2,range2,15)" is returning completely ridiculous results. It matches all the cells in that column with one of two cells within range2 without any obvious logic to it. I know this is all very vague, but what are some errors that could lead to this. I tried reducing the VLOOKUP range and changing the 15 to 2 but that doesn't change anything. How should I proceed?

 

[Takae]

Please try to put "false" or "0" in last of the formula, like VLOOKUP(cell1,range1,2,0) VLOOKUP(cell2,range2,15,0)

 

[RoryA]

Your VLOOKUP formulas require that both lookup tables must be sorted on their first columns. If they aren't, you will get odd results. If you intended to use an exact match, then you should be using:

=IFERROR(VLOOKUP(cell1,range1,2,FALSE)+0,IFERROR(VLOOKUP(cell2,range2,15,FALSE)+0,0))