Interpret Excel Formula with ISERROR and VLookup

[McNeil87]

Hello,

I inherited a file with the following excel formula using ISERROR and Vlookup. I know ISERROR is used to return True for any error type, otherwise, False. But how would i interpret this ISERROR for a specific vell, the doing a Vlookup.. i believe the end states, otherwise, give me cell X2. Any input in how to interpret this formula would be great. thank you!!

=IF(ISERROR(X2),VLOOKUP(J2,'Tracking Codes'!C:E,1,0),X2)

 

[Toadstool]

Hi McNeil87,

Yes, it sounds like you have it. Any interpretation will depend on the formula in column X, i.e. why would it return an error?

If X2 is not in error then you'll get X2, otherwise search all of column C for the contents of J2 and if you find it return it, otherwise you'll get #N/A

McNeil87.xlsx
	B	C	D	E				I	J													W	X
2	1	9							1														#DIV/0!
3	2	1							2														#N/A
4	x	x							X														#VALUE!
5	4	3							4														#VALUE!
6	#N/A	2							5														#VALUE!
7	#N/A	1							6														#VALUE!
8	7	4							7														#VALUE!
9	A	7							8														A
10	B	9							9														B
11	C																						C
12	D																						D
Tracking Codes

Cell Formulas
Range	Formula
X2	X2	=1/0
X3	X3	=VLOOKUP(1,X2,1,0)
X4:X8	X4	=MAX("A","B")
B2:B12	B2	=IF(ISERROR(X2),VLOOKUP(J2,'Tracking Codes'!C:E,1,0),X2)

 

[McNeil87]

Thank you!