Get instant live Excel expert help with LOOKUP Function

hello I am not sure what formula to use. I have a table in a spreadhseet which shows client names, codes and their department numbers. The second spreadsheet has all the invoices received for each client in a month, rather than looking up and typing the department code for each client i want to enter a formula which will look it up and enter it ofr me. think it is a lookup formula but not sure, can you help?

need help finding # amiibos sold in particular region. i have a scalar needed to do rank lookup for the scalar ,specifying using vlookup *population in particular region *22% have a nintendo 15% of those have amiibos (10-rank)^2/100, square the value of (10-the rank value)/100

I need help with lookup formula. If value in colum A in sheet1 is present in colum A in sheet2, I need the value from colum E in sheet2 to show up in Colum H in sheet1.

For the midterm project you will design and create a workbook. The workbook should help solve some problem or serve a purpose that is of personal value to you, a friend or an associate. Create a short description of the workbook you plan to create as descrbied in Part I of the project. Keep in mind that your workbook must implement the technical requirements described in part II. CS302 Midterm Project Part I: Write a description of the Excell workbook you plan to create. Be sure to choose a project concept that will be of personal use to you, a friend or work associate. Preview your description with your instructor for approvail before proceeding to part II In your description include the following: 1. Who will use the workbook 2. Describe what the workbook will do (What purpose will it serve?) 3. Describe the type of data that will be stored in the workbook 4. Describe some of the analysis and reporting features of the workbook. Midterm Project Part II: Create the workbook to complete your project. Your workbook must implement the following technical requirements. 1. Well formatted with some background color, borders and style 2. Contain at least one database sheet with at least 15 records and 4 fields of data and at least one calculated field. 3. Apply appropriate named cell references to your workbook. 4. Implement goal seek analysis using absolute cell references and an assumption area. 5. Use conditional formatting on the database sheet. 6. Use two or more of the functions from this list: if(), iferror(), sumif(), countif() 7. Use a database lookup function like VLOOKUP() using a lookup table. 8. Create a filter sheet that will demonstrate the use of numberic and text filters applied to your datasheet. 9. Create some scenarios and generate a summary report. 10. Add at least one macro with a button to run the macro. 11. Use solver in some way. Be sure to create an answer report. 12. Add appropriate and consistant data validation fields 13. Create 2 charts of different styles using different data. Include examples of data labels, modify axis settings, legends and titles. 14. Add an imbedded image with a link to a web web site. 15. Add cell and worksheet protection. Highlight the unprotected cells. Make the password "MIDTERM". 16. Be sure to add comments to your project workbook pointing to each of the requirements above. Include the requirement number as the first line in the comment. The comment should point to where you implemented each of the technical requirements. To add comments right click the cell and select the insert comments menu option. 17. Add a sheet to your finished workbook named INDEX. The INDEX will list each of the technical requirements above. The INDEX sheet should be the first sheet in your sheet tab. In the A column of the INDEX sheet create a list titled 1 thru 16 matching up with the 16 technical requirements. Add a hyperlink so that when the instructor clicks on the link it will goto the worksheet and cell containing an example of the technical requirement. In the B column add a short description of your implementation of the technical requirement. This is required for grading purposes. If these hyperlinks are not added to your workbook it will affect your project grade. Submit your description document and project workbook for grading.

I really need help solving excel problems like applying lookup functions.

I have a list of store names. Is there a function to have the cell lookup the phone number on google and insert it?

need to do a v lookup across 2 sheets - where no match is found include name in column B

Trying to lookup multiple values to appear individually related to a single cell value

Working in a factory, I have a spreadsheet with multiple worksheets that each represent a running line in the factory. The spreadsheet is used to enter the following data: Date, Time, Change, By Whom. This is filled out when a change is made to a line. Is there a way to lookup the latest date/time entries and display them on a separate sheet labelled 'Latest Changes'. I would also like this to display an extra column dubbed 'Name' which I need to populate with the title of the sheet that I get the info from.

I've created a picture lookup using index, match and name manager - just wondering if I can copy this down easily to the other cells or if I need to create a new formula each time?