Hi, I've advanced a lot with my excel considering it was zero a few months ago. I always get a bit confused with IF function often going to Youtube for help.
The items in Column F are stock and their price is in Column H. I want Column H to always return it's price if the user inputs data in Column F.
For example if I type Pencils in Column F I want Column H to return 0.11.
See attachment for reference.
Thanks Andy
Bookmarks