If Then Statements Linked to Data Validation Lists on Different Sheet

Good morning. On Sheet1 I'm attempting to auto populate specific cells in columns B,C & D with information found in Data Validation lists (found on Sheet2) based on the "value" chosen from a list in column A. For instance,

If A2=Pig Then B2=Slop, C2=Pen, D2=Food

Would someone point me in a direction that might get me to where I'm trying to go? Is this best accomplished through VBA or a basic Function? Thanks.

Matthew

xlbiznes,

Thanks for starting me in the correct direction. In my example I laid everything out in a traditional table format and I can see how your solution works perfectly. There are times when I'll need the values in column A to auto populate cells in different columns and rows (see attached example). I've played with the formula you provided in an attempt to have it work under the condition I've mentioned above and I can't seem to make it work. Would the vlookup solution still be ideal for this scenario?

Thanks.

Matthew

xlbixnes,

I figured it out...thanks for the nudge in the right direction. I've attached my final product. Thanks.

Matthew