Share via

Combining an if error vlookup and if vlookup

Anonymous
2022-05-13T16:21:15+00:00

I am trying to create a formula that is a combination of a if vlookup and and iferror vlookup

Both formulas work separately but I can't combine them. Maybe it's becuase it is Friday and it's been a long week but I would really appreciate your help

I've tried to combine the formulas with formula 1 first and then formula 2 and also vice versa with no success

Can you help

Formula 1

=IF(VLOOKUP(A2,SHEET!A:H,8,FALSE)<>H2,"Yes","No")

Formula 2

=IFERROR(VLOOKUP(A2,SHEET!A:H,8,FALSE),"")

Essentially I am saying, if the value has changed compared my look up table show "Yes", if not, show "No", if there is nothing to return from my look up table, show blank

Many thanks for your help in advance

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2022-05-13T16:34:00+00:00

. . . Formula 1

=IF(VLOOKUP(A2,SHEET!A:H,8,FALSE)<>H2,"Yes","No")

Formula 2

=IFERROR(VLOOKUP(A2,SHEET!A:H,8,FALSE),"")

Essentially I am saying, if the value has changed compared my look up table show "Yes", if not, show "No", if there is nothing to return from my look up table, show blank . . .

Hi,

Please try: =IFERROR(IF(VLOOKUP(A2,SHEET!A:H,8,FALSE)<>H2,"Yes","No"),"")

Please respond if You require further assistance. I will try My best to be of help.

If I was able to help You, please mark My response as answer and helpful.

Thank You!

Was this answer helpful?

1 person found this answer helpful.
0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-05-14T10:02:30+00:00

    Thank you so much - this is perfect!

    Was this answer helpful?

    0 comments
  2. HansV 462.6K Reputation points
    2022-05-13T16:24:31+00:00

    For example

    =IF(IFERROR(VLOOKUP(A2,SHEET!A:H,8,FALSE),"")<>H2,"Yes","No")

    Was this answer helpful?

    0 comments