Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Value
I am not very good at this sorry :)
I have a list on sheet 2 the shows the area numbers (A2:A97), area leader (B2:B97) and area manager (C2:C97). On sheet 1, I have a list of activities outstanding for areas (numerous for each area). The area number is listed automatically on this sheet. I need to have the area leader and area managers name inserted onto this sheet. I have no idea on how to look up the value from the other sheet. I would appreciate any help. Thanks Nic |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Value
Hi
Try =VLOOKUP(A1,Sheet2!$A1;$C1000,2,0) to find the Area Leader and =VLOOKUP(A1,Sheet2!$A1;$C1000,3,0) to find the Area manager Change the range $A$1:$C$1000 to match the extent of your data on Sheet2. -- Regards Roger Govier "Nic" wrote in message ... I am not very good at this sorry :) I have a list on sheet 2 the shows the area numbers (A2:A97), area leader (B2:B97) and area manager (C2:C97). On sheet 1, I have a list of activities outstanding for areas (numerous for each area). The area number is listed automatically on this sheet. I need to have the area leader and area managers name inserted onto this sheet. I have no idea on how to look up the value from the other sheet. I would appreciate any help. Thanks Nic |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unable to insert columns in excel, insert- columns (disabled) | Excel Discussion (Misc queries) | |||
Can I auto insert a worksheet when I insert a value in a cell. | Excel Worksheet Functions | |||
Insert Next? Or insert a variable number of records...how? | Excel Discussion (Misc queries) | |||
How do I insert a reference to lookup and insert a name | New Users to Excel | |||
How do I insert a comment when the Insert:Comment menu is greyed? | Excel Discussion (Misc queries) |