Explain Formula

[Allison]

I need to understand this formula in layman terms!!!



Under to column heading Record Match this appears on a
spreadsheet forwarded from my co-worker

=IF(ISERROR(VLOOKUP($AV3774,NONCOM!
$A$2:$AP$5221,28,FALSE)) = FALSE,TRUE,FALSE

HELP!!!

 

[Mark]

The VLOOKUP bit is comparing a value in cell AV3774
against a table of data on a sheet named "NONCOM" located
in cells A2 to AP5221. The data that will be returned is
located in column 28 of this table.

The ISERROR bit is just checking whether the data to be
returned contains a value such as #N/A.

So....

If the VLOOKUP is NOT going to return an error such as
#N/A it returns a value of "TRUE". If an error is present
it returns a value of "FALSE"

In summary it's a data quality check.
TRUE indicates data is present
FALSE indicates an error

 

[Allison]

Thanks All!!!

-----Original Message-----
The formula looks in the first column of the table at NONCOM!A2:AP5221 for
the value of cell AV3774 . If it finds it, it will return TRUE, otherwise
FALSE. Basically, it answers the question: "Is AV3774 in the table?





.

 

[GB]

Leo, I am getting confused, but maybe only because there is possibly a
closing bracket missing from the formula below (and from all the other
formulae quoted previously). Is that right?

Geoff

 

[Leo Heuser]

Geoff

I can understand your confusion.
For my explanation, I just copied the original
formula (with a missing bracket) and was so
focused on explaining the mechanics of the formula,
that i didn't notice the missing bracket

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.

Leo, I am getting confused, but maybe only because there is possibly a
closing bracket missing from the formula below (and from all the other
formulae quoted previously). Is that right?

Geoff

 

[GB]

Thanks for confirming.

Geoff

I can understand your confusion.
For my explanation, I just copied the original
formula (with a missing bracket) and was so
focused on explaining the mechanics of the formula,
that i didn't notice the missing bracket

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.

"GB" <[email protected]> skrev i en meddelelse