I have a similar list in the first worksheet of my spreadsheet to your table example:
In the next (second) worksheet, I would like their age to appear automatically when their name is selected from a drop-down i.e. If I pull-down Kate in Cell range A1, cell B1 will get populated with 25.
I'm assuming the formula would have to sit in B1 but, I'm not sure at all what formula would do the trick.. . any help would be greatly appreciated?
Many many thanks,