Get instant live Excel expert help with VLOOKUP formula

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I was wanting to see if there is a formula or vlookup i could use to populate data into another sheet by date
Solved by D. F. in 24 mins
Hello - Vlookup question: In my workbook, if data from Tab 'BYOD Groups' Column C matches data from Tab 'ETFs' Column F, I need to populate data from Tab 'ETFs' Column G into Tab 'BYOD Groups' Column B for those matching values . What kind of a formula can I use to do that?
Solved by T. S. in 27 mins
I have a list of file, the format is not consistent but the dimension of the file and the product code will definitely be contained in the file name. If I were to given a list of Product codes and File dimension, would I be able to use a vlookup formula to find the associated file?
Solved by O. W. in 15 mins
Hello how does vlookup work. I see on the formula that there is a value, table, index-number, [app_match]. Especially on calculations
Solved by V. J. in 14 mins
Hello I need help in this step. I think i need to use the VLookUp formula but don't know how to change the amount to move up the cell.
Solved by B. F. in 21 mins
Excel Sheet: I have a sheet I need to summarize by Resource, but must still include: Department, Project Number, and total hours by project. Hurdle, project and project number is only on one line. I think it is a combination of formula and vlookup possibly into a new sheet. Any help is appreciated
Solved by T. S. in 14 mins
I currently have this Formula : =IF(C12<=500,VLOOKUP(C6,'Table 1'!B5:G35,3,FALSE)*Calculator!C12+250,IF(AND(C12>=501,C12<1001),VLOOKUP(C6,'Table 1'!B5:G35,4,FALSE)*Calculator!C12+250,IF(C12>=1001,VLOOKUP(C6,'Table 1'!B5:G35,5,FALSE)*Calculator!C12+250))) I wish to have it if C6 is Norway +170 and if it is switzerland + 100.
Solved by G. U. in 30 mins
I have two worksheets. In first one, user selects an item from drop down menu and second sheet contains all the items and associated numbers for each item. When a user selects Item4 from drop down menu, vlookup gets the associated numbers for it in next cell. Now, I need to have button/checkbox/anything that can divide, multiply or revert back to original the number associated with the item number. Eg. Sheet2 got Item1 that values 1, 5, 0 each in their own cell. Below is Item2 that got values 0, 5, 0 Sheet1 allow user select multiple items below each other and at last there is SUM function which sums all numbers in each column (1+5, 5+5, 0+0) What is hard here, is when user wants to divide Item1's values by 2 to 0,5 - 2,5 - 0 without rendering the vlookup formula useless.
Solved by K. Y. in 28 mins
Is there any way to have a formula that fills in an entire row on a table based on the information given in the first cell of that row using another tab as the data base? We are creating our own invoices for a new venture, and have several hundred SKU items (with descriptions, commodity codes etc) that need to go onto the invoice. IF we put all the information on a second tab/sheet, can we pull this through to the first sheet, possibly with a dropdown menu in the first column to select the appropriate SKU. I had initially thought of a VLOOKUP but don't think this will pull through all the information needed
Solved by M. H. in 28 mins
I have two columns of email addresses and want to find it any exist in both columns using VLOOKUP - can you provide the formula for the excel match two columns?
Solved by X. B. in 14 mins