My problem is as follows.
Have a number in cell B2 (on Sheet 1), and i have an array (Sheet 3, $A$2 to $B$127). The number in Cell B2 may or may not appear in column 1 of the array. If it does, i need the number in column 2 of the array, as the answer to my lookup. The numbers in column 2 of the array are 0 or 1.
The formula only gives me the correct result, when the conditions are met, i.e. there is a corresponding number in column 1 and cell B2, in all other instances the answer is #N/A. I would like a blank or 0 as the answer.
=VLOOKUP(B2,Sheet3!$A$2:$B$127,1,FALSE)
Any help would be appreciated
Have a number in cell B2 (on Sheet 1), and i have an array (Sheet 3, $A$2 to $B$127). The number in Cell B2 may or may not appear in column 1 of the array. If it does, i need the number in column 2 of the array, as the answer to my lookup. The numbers in column 2 of the array are 0 or 1.
The formula only gives me the correct result, when the conditions are met, i.e. there is a corresponding number in column 1 and cell B2, in all other instances the answer is #N/A. I would like a blank or 0 as the answer.
=VLOOKUP(B2,Sheet3!$A$2:$B$127,1,FALSE)
Any help would be appreciated