apologies

My apologies if this has already been asked and answered, but I'm not sure I even know what to search for :) I was wondering if there was a formula (or method) for excel to auto-complete or auto-fill data to the right using data pulled from another source when a value from a drop-down list...

Good day, I have been using a formula below to calculate SP id's and sale amounts. It worked fine but suddenly it does not pick up the next ID number. Apologies - I do not know how to paste the example properly. {=INDEX($H$20:$H$29,MATCH(SMALL(IF(COUNTIF($K$19:K19, $H$20:$H$29)=0...

Good morning all, I'm getting an error that is (as errors usually do) driving me crazy! It is a fairly simple calculation that works on hundreds of other lines ... except for one. The cell in question is M36 Apologies, as this is my first post and I do not know how to attach a spreadsheet...

Hi, I wish to validate a cell (lets say A1) as below. - If B1 = "cat" then allow dropdown List 1 - If B1 = "dog" then allow dropdown List 2 - If B1 = "fish" then allow free text / anything Any ideas? Help appreciated. Apologies if an answer has already been posted but i couldnt find it...