Excel 2007 : Mindbender Formula Help

[GrnAlien]

I have been making this spread sheet for 2 years. Listed below is a link to a small portion of it. I cant figure out how to auto populate a table from a different tab based on a single cell selection. Please help me because this is driving me nuts, not to mention making me blind!! hhahah. The exact problem is listed on the first tab of the spread sheet along with my email address if you are able to help complete the spreadsheet.

Cheers,
Mr. GrnAlien

http://www.grnalien.com/Cooking.xlsx

[shg]

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

[GrnAlien]

wow, got it thx, sorry if I broke the rules

[royUK]

Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

And another one, read the rules before posting again