Help Creating Excel Sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2668843%22%20slang%3D%22en-US%22%3EHelp%20Creating%20Excel%20Sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2668843%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20am%20looking%20to%20create%20a%20spread%20sheet%20to%20assist%20in%20pre%20populating%20rates%20based%20on%20service%2C%20role%20and%20time%20so%20it%20pulls%20in%20the%20correct%20rate%20based%20on%20certain%20fields%20along%20with%20hours%20based%20on%20start%20and%20finish%20time%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2668843%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%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-2669219%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20Creating%20Excel%20Sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2669219%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1133198%22%20target%3D%22_blank%22%3E%40jcoates40%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20absence%20of%20a%20sample%20of%20the%20spreadsheet%20you've%20created%20so%20far%2C%20the%20most%20anyone%20can%20offer%20is%20general%20advice.%20So%20here's%20some%20general%20advice.%3C%2FP%3E%3CP%3EExcel%20is%20good%20working%20with%20tables%20as%20sources%20to%20look%20up%2C%20for%20example%2C%20rates%20based%20on%20service%20and%20role.%3C%2FP%3E%3CP%3EDo%20some%20research%20on%20the%20%3CSTRONG%3EXLOOKUP%3C%2FSTRONG%3E%20function%2C%20for%20example.%20Also%20%3CSTRONG%3EINDEX%3C%2FSTRONG%3E%20in%20collaboration%20with%20%3CSTRONG%3EMATCH%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3EExcel%20is%20also%20good%20at%20determining%20lapsed%20time%20between%20two%20date%2Ftime%20entries.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20a%20link%20to%20a%20good%20website--there%20are%20others--that%20can%20help%20you%20with%20the%20syntax%20on%20those%20functions.%20I've%20already%20set%20it%20to%20the%20%3CSTRONG%3EXLOOKUP%3C%2FSTRONG%3E%20function%20for%20you.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Fexcel-functions%2Fexcel-xlookup-function%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceljet.net%2Fexcel-functions%2Fexcel-xlookup-function%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20want%20more%20specific%20help%2C%20please%20post%20a%20copy%20of%20the%20spreadsheet%20you%20have%20developed%20so%20far.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi,

 

i am looking to create a spread sheet to assist in pre populating rates based on service, role and time so it pulls in the correct rate based on certain fields along with hours based on start and finish time

1 Reply

@jcoates40 

 

In the absence of a sample of the spreadsheet you've created so far, the most anyone can offer is general advice. So here's some general advice.

Excel is good working with tables as sources to look up, for example, rates based on service and role.

Do some research on the XLOOKUP function, for example. Also INDEX in collaboration with MATCH.

Excel is also good at determining lapsed time between two date/time entries.

 

Here's a link to a good website--there are others--that can help you with the syntax on those functions. I've already set it to the XLOOKUP function for you. https://exceljet.net/excel-functions/excel-xlookup-function

 

If you want more specific help, please post a copy of the spreadsheet you have developed so far.