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 |
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 |
All times are GMT +1. The time now is 02:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com