Conditional Fill Series?

[Mavlon]

Hello everyone,

I am new to the forum and would like to thank anyone in advance for their help.

Firstly, I was able to get this formula working yay!!

=IFERROR(VLOOKUP(C2,'Etilize_ProductRichContent (ALL'!C2:C3171:'Etilize_ProductRichContent (ALL'!E2:E3171,3,0),"")

Now I need to fill the series for only the first part of the formula. This is what the next line should look like:

=IFERROR(VLOOKUP(C3,'Etilize_ProductRichContent (ALL'!C2:C3171:'Etilize_ProductRichContent (ALL'!E2:E3171,3,0),"")

Only the bolded area changed, but when I do fill series, everything changes.

Cheers!!
Mav

 

[Mavlon]

Nevermind, I figured it out myself

=IFERROR(VLOOKUP(C3,'Etilize_ProductRichContent (ALL'!$C$2:$C$3171:'Etilize_ProductRichContent (ALL'!$E$2:$E$3171,3,0),"")

Cheers!
Mav