Thread: Search and input in sheets

I have tried, looked & asked everywhere and can't figure this out. I will try to explain.

I have a wookbook with 6 sheets I need to do the following:

Input a # on sheet 1 in cell A 32 - then I need to have excel search sheet 6 colums A1 - A30 for that # then input the description from column C, Row ? (the row would be where excel found the #) and input it in B 32 on sheet 1.

I would then like to do the same thing for A 33 etc.


I really hope this can be done - will cut so much time of my workload.

Thanks in advanced
Z