Apologises if I have come to the wrong thread section.
I am looking to populate cells with numeric values based on the text content from another cell
For example if Call A1 says "Flooring" I need cell B1 to automatically show 25
There will be 10 possibilities for for the text and each one requires a link to different value
The cells in Row A will be selected from a limited drop down table
is this possible?
Thank you in advance
Carl
Bookmarks