Are you stuck on Excel or Google Sheets?

Check out some problems solved by our top Experts or click here to post your own problem for free!

I need a formula (I think VLOOKUP) that will enable me to: Use data from one column, compare with another and tell me the difference. Im a teacher and want to work out the amount of marks needed to the next grade boundary. I've created the rest, but this has me stumped!
Solved by F. A. in 28 mins
Please insert a formula into column D that brings the code from Column H into Column D, using VIN in column I as the look up factor. I think this is a vlookup function but I am struggling
Solved by C. A. in 40 mins
I need help with vlookup. I need to move data from 'wk1' E to 'Destination sheet'AT if helper columns G match. Also I do not want to erase any data that is currently in the cell.
Solved by G. Q. in 40 mins
VLOOKUP help. Trying to input data from database into new table
Solved by S. Q. in 40 mins
Need some help regarding array, vlookup and if statement
Solved by Z. Y. in 20 mins
I have two lists. One is a list of part numbers. The other is a list of long text descriptions. I can use VLOOKUP with "*"&cell address"*" to find the first match. But how can I find the second and third matches? I have tried using INDEX and SHORT but the wild cards no longer find the match like they do in VLOOKUP. Can you help?
Solved by S. J. in 36 mins
My vlookup is not pulling in all data, i need help as to why it's displaying errors
Solved by B. D. in 19 mins
Please help me to use vlookup when serial # isn't on far left
Solved by V. C. in 12 mins
I have a spreadsheet that lists customers. Column A row 2 has an entry of 1 and goes all the way up to 418. Column B is a list of Customers. Columns C, D, E are the employee ID associated to each customer. I am having a hard time creating vlookup to pull all customers associated to one specific employee id# related to multiple clents for that employee's ID. Please help.
Solved by C. U. in 43 mins
I'm trying to say if the value that returns from the v-lookup is 00/01/1900 leave blank, this part I have done, but then I want it to say if there is a real date to put that. That's where I'm stuck. So far I have the following: =IF(VLOOKUP(RC[-8],[MLS_Board_2018.xlsx]Domestic!C1:C16,16,0),00/01/1900,"") Please can you help? Thank you.
Solved by S. D. in 11 mins
1 2 3 4 5 6