Hello,

I need help and can't seem to find my error.

The following statement is meant to look for a value in column B, if it matches, do a v-lookup to pickup info from another column.

=IFERROR(IF('Ad Details'!$B$1:$B$6000=$A21,VLOOKUP(C$4,'Ad Details'!$E:$K,7,FALSE), ""), "")

When I replace above formula with exact cell to look at, the formula works.

=IFERROR(IF('Ad Details'!B7=$A21,VLOOKUP(H$4,'Ad Details'!$E:$K,7,FALSE), ""), "")

Please help!

Thanks!