If Statement with Vlookup

[greentea]

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!

[FDibbins]

That looks like an ARRAY function, but not sure it will work that way anyway.

In the 1st formula, you are trying to compare an entire range with 1 cell value

Maybe try something like IF(countif('Ad Details'!$B$1:$B$6000,$A21=1,...........................

[FDibbins]

That looks like an ARRAY function, but not sure it will work that way anyway.

In the 1st formula, you are trying to compare an entire range with 1 cell value

Maybe try something like IF(countif('Ad Details'!$B$1:$B$6000,$A21=1,...........................

[greentea]

I've attached the excel file.

Desperately need a solution here! Basically, need to transport data in the "Ad Details" to the Calendar View" tab.

thanks again!

[greentea]

Still looking for help!

[Yogi52o]

Use COUNTIF as your triggering event for the VLOOUP:

Please Login or Register  to view this content.

[Punnam]

hi,

Is this help full .
Punnam Ravi

[boopathiraja]

Try the below array formula

Please Login or Register  to view this content.

[cbatrody]

Hi,

Please see the attached file. I have used an array formula here, you need to press CTRL+SHIFT+ENTER to confirm.

=IFERROR(INDEX('Ad Details'!$A$1:$I$18,MATCH($A6&C$4,'Ad Details'!$A$1:$A$18&'Ad Details'!$C$1:$C$18,0),9),"")

[greentea]

Hi Everyone,

Big thank you for all your suggestions! I couldn't wait last night so I concatenated the rows and did a lookup into my calendar. It seems to work

Thanks again