vlookup a cell with a formula and iferror copy cell

[bobbieatendido]

Hi,

Is it possible to vlookup a cell that contains a formula?

International code is internationalcode+lot#
Hidden is a "hidden column" that contains a formula to only get the international code =left(B2,6)
Local code is a vlookup of column C
Product Name is a vlookup of column D

Note: Not all products have an international code
Column D needs to be a: vlookup C2, if the data is blank then copy column B2

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1	Order#	International Code	Hidden	Local Code	Product Name				Data
2	2	123456654321	123456	123456654321	0				International Code	Local Code	Product Name	Price
3	3	234567765432	234567	234567765432	0				123456	111-111	TBS Crossfire Nano RX	25
4	4			0	0				234567	111-112	TBS Crossfire Nano (SE)	30
5	5			0	0				345678	345678	TBS Tracer Nano RX	30
6	6			0	0				456789	456789	TBS Micro TX	70
7	7			0	0					A1500	Ethix Mambo	190
8	8			0	0					A1600	FRSky Xlite	140
Sheet1

Cell Formulas
Range	Formula
D2:D8	D2	=IFERROR(VLOOKUP(C2,I:J,2,FALSE),B2)
E2:E8	E2	=IFERROR(VLOOKUP(D2,J:K,2,FALSE),0)
C2:C7	C2	=LEFT(B2,6)

Thank you.

 

[bobbieatendido]

For D2, its supposed to be 111-111 since C2 has a value from the "Data"
if in B2 I wrote A1500, since there is no A1500 in Column I, then D2 should just copy B2.

 

[Fluff]

How about

=IFERROR(VLOOKUP(C2+0,I:J,2,FALSE),B2)

 

[bobbieatendido]

How about

=IFERROR(VLOOKUP(C2+0,I:J,2,FALSE),B2)

Thank you it worked!!!

 

[Fluff]

You're welcome & thanks for the feedback.