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

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