Quote Originally Posted by FDibbins View Post
OK I have looked at your file, and dont see why you feel the need to use vlookup?
If you need to know the reason as to why I need to use vlookup function before helping me with it, then no problem, I can say it.
Because I want to see how vlookup can be implemented here in order to do what needs to be done in a new column designated for the discounted prices.
So I guess it's curiosity.
Quote Originally Posted by FDibbins View Post
vlookup is used to search down a list if items for a specified item, and then to return a corresponding value from a defined column.
yes, I know.
Why can't it return the price from the first column, if the corresponding cell from the second column matches up for the "YES" value?
Quote Originally Posted by FDibbins View Post
Looking at what (I think) you want, canapone's suggestion in post # 2 will give you exactly what you want.
I wonder if I respond to this part of your post by stating the obvious, would I be again accused of something that is supposed to be socially unacceptable?

I really don't know how to make it clearer that I need it work only by the use of the formula vlookup.
It can be used with the if statement inside it, but it has to be vlookup.
Does anyone know how to do it with the vlookup function? If yes, say it, if no - then be aware that it's not what the question of this thread is asking for.