Looking up different data sets depending on option selected.

Hi

Please see attached document

In Column B, when I write the department name, I want it to automatically use the appropriate data set on the right hand side (G3:N10).

So if I say 'vegetables' in B2, it will automatically select the data table named vegetables to select the appropriate number based on the other criteria in A2 and C2.

If I say 'fruit' in B2, it will select the data table named Fruit etc etc.

Thanks for any help with how to do this automatically.

S

Put this in E2:

Formula:

Please Login or Register  to view this content.

and copy down.

Hope this helps.

Pete

Amazing Pete, thank you! Wish i'd posted on here about 5 hours ago now!!!

hi again

i changed the company names from numbers to words - now it is coming up with a blank result. is there any way to solve this? thanks

Have you changed them in column G as well as in column A? Perhaps you could re-post another example so I can see what you've got now.

Pete

new example here. thank you!

Hi Sarah,

the formula in E2 should now be as follows:

Formula:

Please Login or Register  to view this content.

then copy down as before.

Hope this helps.

Pete