Conditionally pull data from another list
Closed
eskagsms
Posts
24
Registration date
Wednesday February 9, 2011
Status
Member
Last seen
May 30, 2012
-
May 29, 2012 at 07:14 AM
eskagsms Posts 24 Registration date Wednesday February 9, 2011 Status Member Last seen May 30, 2012 - May 30, 2012 at 06:40 AM
eskagsms Posts 24 Registration date Wednesday February 9, 2011 Status Member Last seen May 30, 2012 - May 30, 2012 at 06:40 AM
Related:
- Conditionally pull data from another list
- Transfer data from one excel worksheet to another automatically - Guide
- My contacts list names - Guide
- Counter strike 1.6 cheats list - Guide
- Display two columns in data validation list but return only one - Guide
- How to change your best friends list on snapchat to 3 - Guide
2 responses
Mehedad
Posts
22
Registration date
Thursday April 19, 2012
Status
Member
Last seen
April 16, 2013
3
May 30, 2012 at 05:00 AM
May 30, 2012 at 05:00 AM
I think you can use VLOOKUP in the Column F of Callog.xls
Incase you don't know what VLOOKUP is, apply the below formula in F2 of Callog.xls:
=VLOOKUP(E2,'[Tracker.xls]Sheet1'!$C:$D,2,FALSE)
Both the workbooks have to be open when the formula is entered or else you need to specify the File Path in the formula. And the column (Col C) in Tracker.xls has to be sorted in Ascending order (Sort A to Z).
Please check the sheet name in Workbook Tracker.xls and change accordingly in the formula.
Let us know if it worked.
Incase you don't know what VLOOKUP is, apply the below formula in F2 of Callog.xls:
=VLOOKUP(E2,'[Tracker.xls]Sheet1'!$C:$D,2,FALSE)
Both the workbooks have to be open when the formula is entered or else you need to specify the File Path in the formula. And the column (Col C) in Tracker.xls has to be sorted in Ascending order (Sort A to Z).
Please check the sheet name in Workbook Tracker.xls and change accordingly in the formula.
Let us know if it worked.
eskagsms
Posts
24
Registration date
Wednesday February 9, 2011
Status
Member
Last seen
May 30, 2012
May 30, 2012 at 06:40 AM
May 30, 2012 at 06:40 AM
That worked great even without not sorting. Thanks a lot.
