Vlookup - search value of one column if blank, use another column

[Kmkreamer69]

Current formula:
IFERROR(VLOOKUP($A11,$B:$I,8,FALSE),"")

Pulls from column 8, would also like to pull from column 11 if column 8 is blank

Would like to add if the cell is blank, look up in value in another column. Any assistance would be greatly appreciated.

 

[etaf]

ignore not sure now

IF A11 is not in the column B , you get an ERROR and hence blank
IF the value is not in column 8 , then a zero is returned

Book3
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1														0
2
3		1							2
4		2
5		3							4
6
7
8
9
10
11	2
12
Sheet1

Cell Formulas
Range	Formula
N1	N1	=VLOOKUP($A11,$B:$I,8,FALSE)

SO the reason you get a blank is because of the IFERROR telling you column B does not match A11
Otherwise you should be returning a zero

or have I miss undersrtood