Could someone please help, I am trying to write a formula that will allow me to type a number in cell E17 that will putt a name in G17 and a value in I6.
The name for G17 comes from columbs A20:A51 and the value comes from E20:E51 (D20:D51 are purchase rates, E20:E51 are with a percentage markup).
This is my 1st time using this forum and have not yet worked out how to add an attachement? If it helps for you to see the very small simple spreadsheet just let me know how to attach it!!
Thanks
Bookmarks