Can someone tell me what this formula means?

I'm trying to decipher a progam but don't know what this is saying:

=IF(ISERROR(VLOOKUP($C17,'6'!$B$1:$E$25,4,0))=TRUE,"",VLOOKUP($C17,'6'!
$B$1:$E$25,4,0))

I understand that it's doing a VLOOKUP of what's in cell $C17, but the
'6' part attached to the table is throwing me off. Also, does the
=TRUE thing mean I'm NOT looking for an exact match?

Can anyone put this into English for me?

.

Relevant Pages

  • RE: Any sugguestion to set up this Calculation?
    ... You can use VLOOKUP() with IFstatements, ... According to the below sample the 0.65 is a fit rate cell but i need to be ... we will say that sheet has been named CostTableSheet ... I am thinking a way to set up a template for other to use. ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Any sugguestion to set up this Calculation?
    ... I had a table consist of three Country. ... on my template I need to choose a correct country. ... Think of VLOOKUP as a single value, and it can be used in formulas just like ... According to the below sample the 0.65 is a fit rate cell but i need to be ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Any sugguestion to set up this Calculation?
    ... I had a table consist of three Country. ... on my template I need to choose a correct country. ... Think of VLOOKUP as a single value, and it can be used in formulas just like ... According to the below sample the 0.65 is a fit rate cell but i need to be ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Any sugguestion to set up this Calculation?
    ... Can Vlookup compare a few cell? ... For example for B P2PRate I need to compare a few cell. ... we will say that sheet has been named CostTableSheet ... I am thinking a way to set up a template for other to use. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Returning 0 instead of #N/A when no value is found
    ... If you've used VLOOKUP a bazillion times I can say with certainty that I've ... The true underlying value of cell A1 may be 100.000002456 ... An empty cell evaluates as 0 depending on what type of function/formula ... You have to start from the position that *Excel is always right* and find ...
    (microsoft.public.excel.worksheet.functions)