Get instant live Excel expert help to learn how to use Find function in Excel?

I have a list of names in Column A and a list of telephone numbers in Column B. The are both on the same spreadsheet "NAMES & NUMBERS". On a different spreadsheet, within the same workbook, I would like to have a drop down where I can choose the name in A1 and it will automatically populate A2 with the corresponding telephone number for that particular person. I have searched for 2 hours on the web trying to find out how to do this. Please help!

Want to find rank on excel for those whose pass in all subjects

I have two email columns, one of which links to a variable. I've sorted the necessary duplicate, but I'm stuck on a formula to find the variable i need.

After i had choose "AB12/AB08 WHITE HIGH VOLTAGE" in the column I, there are only left four row of data. I want to sort the data by date in Column O. (either new to old, or old to new). However, come out with "Operation require the merged cells to be identically size". I had do some research online but there are only suitable for fixed data(no add data anymore.) Since I need to add more data in the lower row, I need to find a easier ways to settle this. Are there any solution? Thanks for your help

I have three steps I must do which involves me dealing with vlookups and no matter what I look up, I am still confused and can't get my formula to work. I need help please! step 1: Switch to the worksheet “Internet user and pop. Table”. Use a VLOOKUP function in cell F2 so that it searches for the country in A2 (of current worksheet) that also appears within the “2016” worksheet and display its number of internet users. Expand the formula down to find the number of internet users for each country. Step 2:In the cell G2, use a similar VLOOKUP function to display the population for that country. Expand the formula down to find the population for each country. Step 3:In cell J2, use a formula to calculate the % of the population that uses the internet. Use the same calculation for each country.

I'm having a problem with a formula and I am not even sure the functionality exists to make this work. For our purposes I have used a fake spreadsheet just to show the basics of what I need. On 'sheet2' of my workbook I want to return a value from 'C4' on 'sheet1', however, I want the row to change with B3 on 'sheet2'. For instance: =Sheet1!C4 // returns the value I want, but doesn't allow me to easily change the row I want to find when I switch to another sheet. ( I will have at least 100 different formulas that will change with the row number. =Sheet1!C(B3) // doesn't work, but is essentially what I want. So that if I change b3 to 5, the formula will look in =Sheet1!C5

formula to find the biggest loss and win the average lose and win total wins all for the specific stock based on all my data Thanks

Hi, I am one of the Administrators of my company, supervising the contact lead and customer cycle together with our sales team. We have used Quickbooks to do so before but needed to add a few more information due to the very specialised nature of our products. Structure of tables enclosed: 1. Contact leads table to be seen as main database from which the 'Inactive' and 'Customers' tables are drawing from (using simple if-formulars) 2. Using filter options in the tables 'inactive' and 'customers' all results showing n/a's are being filtered out. 3. Further Status of orders or reason for why a customer was added through the 'status list' and the data validation excel function. My current problem is: 1. I would like to have an 'automatic running' formular that transfers. Currently my approach is very manual and time intensive as I continously have to further adjust the if-formulas to make e.g. new customers appear in the 'customers' table after the my colleague adjusted their status in the contact leads table. 2. I did try iferror function and did not find the result pleasing. I would greatly appreciate your support! Thank you! Kind regards, Neblina Weggeland

Hi I need to merge 4 different work books (all payroll related). I can't find the developer tool in Excel, and this is my first time ever doing it. Can you help me?

Hi I was just talking to one of your consultants and he made some changes to my worksheet but now I cant find the file to download the ones that are there are not my file