VLOOKUP FORMULA ISSUE

Can I ask you,Maria0009 : is this a spreadsheet that somebody else created and you are maintaining by following some written procedure that that other person gave you?

I ask in part because your own postings here suggest that you have at best a shaky understanding of Excel...but also because there are so very many named ranges in the spreadsheet that are invalid now... whether you created them or somebody else did.

AND I noticed that a few names on the different sheets differed in small ways (e.g., one with a period, the other without) although clearly referring to the same company--the kind of discrepancy that itself (a) will cause VLOOKUP not to work, and (b) is actually evidence of a poor fundamental design. You'd be much better served by using company codes of some kind that are entered once, not repeatedly, and are simple enough to check for consistency. Using a long customer name as the basis for VLOOKUP is something that can work, but is--shall we say--fragile. Simply because VLOOKUP is looking (in your formula) for an exact match, and it's so very easy to add a period to one and not have it in the other, to have a trailing space in one but not in the other, a comma in one and not in the other, an accidental spelling mistake in one and not in the ohter (intentional misspelling there to make the point).

IF indeed you are just maintaining this, and have a limited understanding of the deeper structure--the use of named ranges for example--then I strongly recommend seeing if you can get it back to the originator and asking for a more robust design. If that's not the case, if you are the one who created it, then come back here, please, and explain how some of the anomalies I've described came to be.