IF and VLOOKUP formulas does'nt work

[Cordav]

Good Afternoon

I find this website of help with Excel, and I 'm asking if it possible to you to help me.

I have a propose worksheet, but know I'm trying to do a better worksheet, but I cannot solve some problems that are happening.

Basically what is desired is to have a budget sheet, simple and functional and not heavy.

So I have a sheet (TODASPROPOSTASPORTUGAL.xlsx) that has all suppliers for each brand to have their products and their prices for products and that when the brands release a updated price list is easy to update by brand because they not change at the same time the prices (the name always has the latest update date of the listing).

Then in another sheet (Folha Propostas_TIPO.xlsx) that have the budget that goes to the end in order to make a proposal.

What I want is that when entering a reference, in the following fields for description, price and he'll find this reference on all manufacturers and return the same description and price.

If it happen to find two references to different manufacturers alike, it warns you so you can choose from column A, that price / Manufacturer I want to put.

In the columns that I added, would be to have a clear and quick idea of the proposal in terms of value that is being given to the customer and what the margin of € he would be in business. As% gain in business

Is it possible to give a help then please?



http://www.2shared.com/file/hZRRtJR0...sPortugal.html

Thanks in advance and Best Regards

Cordav

[Cordav]

Hi,

Could some one give a litle help?

Thanks

Best Regards

[zbor]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[zbor]

Also, this Forum allow to upload files (up to 1MB) and we prefere that rather than external links.

[Cordav]

Good Afternoon Zbor.

I have change the title(I put some formulas, because the sheet have many formulas, and they are not working one with another, thas has I do not put in the title a single description, but a general description)

I have uploades one of the file, because the other haver more than 1MB.

I think I made everything you asked.

Could you help me now?

Thansk in advance

Cordav

[Cordav]

Good Afternnoon

I resolve the problem.

The administrators can close the Thread.

Thanks a lot to all who helped me!

Best Regards