Help with look up function

%3CLINGO-SUB%20id%3D%22lingo-sub-3349414%22%20slang%3D%22en-US%22%3EHelp%20with%20look%20up%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3349414%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20%3CSPAN%20class%3D%22lia-unicode-emoji%22%20title%3D%22%3Awaving_hand%3A%22%3E%3CSPAN%20class%3D%22lia-unicode-emoji%22%20title%3D%22%3Awaving_hand%3A%22%3E%3CSPAN%20class%3D%22lia-unicode-emoji%22%20title%3D%22%3Awaving_hand%3A%22%3E%3CSPAN%20class%3D%22lia-unicode-emoji%22%20title%3D%22%3Awaving_hand%3A%22%3E%3CLI-EMOJI%20id%3D%22lia_waving-hand-tone-1%22%20title%3D%22%3Awaving_hand%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3CBR%20%2F%3EHave%20a%20client%20list%20%22master%22%20spreadsheet%20which%20shows%20client%20value%20against%20individual%20account%20number%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20upto%20date%20client%20values%20for%20each%20account%20in%20new%20spreadsheet%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20use%20look%20up%20function%20to%20find%20new%20value%20and%20add%20it%20to%20master%20spreadsheet%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3349414%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3351017%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20look%20up%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3351017%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1064708%22%20target%3D%22_blank%22%3E%40Rubyroadbike%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you're%20on%20365%2C%20this%20sample%20might%20work%20for%20you.%26nbsp%3B%20Please%20see%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3351707%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20look%20up%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3351707%22%20slang%3D%22en-US%22%3EHi%20Patrick%2C%20appreciate%20taking%20the%20time%20to%20reply.%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20master%20sheet%20on%20your%20sample%20has%20a%20function%20which%20assume%20is%20locating%20the%20account%20number%3F%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20looking%20to%20use%20the%20common%20data%20in%20both%20my%20sheets%20(eg%20account%20number)%20to%20identify%20new%20client%20value%20and%20pull%20this%20through%20onto%20the%20master%20against%20the%20client%20number%3CBR%20%2F%3E%3CBR%20%2F%3EAny%20further%20suggestions%20would%20be%20helpful.%3C%2FLINGO-BODY%3E
New Contributor

Hello
Have a client list "master" spreadsheet which shows client value against individual account number

 

Have upto date client values for each account in new spreadsheet

 

How do I use look up function to find new value and add it to master spreadsheet?

 

Thanks!

2 Replies

@Rubyroadbike 

If you're on 365, this sample might work for you.  Please see attached.

Hi Patrick, appreciate taking the time to reply.

The master sheet on your sample has a function which assume is locating the account number?

I am looking to use the common data in both my sheets (eg account number) to identify new client value and pull this through onto the master against the client number

Any further suggestions would be helpful.