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 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
I need help with a vlookup for multiple duplicate references
Solved by M. D. in 16 mins
I need Vlookup help across 2 workbooks into one other main workbook and can't figure out what i'm doing wrong!
Solved by G. E. in 19 mins
Need help with Multiple Vlookup Function. Please only Expert Require.
Solved by Z. J. in 40 mins
I need help on vlookup. CAn you help me wiht that?
Solved by V. H. in 20 mins
HOW TO USE VLOOKUP FOR ENTIRE SHEETWORK AND MULTIPLE TABS?
Solved by T. Y. in 40 mins
I have 2 columns of data. Column A with a list of items (say computer SN) and Column B with a list of Sub items (accessories). An Item (column A) can have multiple sub items (column B) and vice versa. ColumnA ColumnB Item1 SubItem1 Item2 Subitem3 Item1 Subitem3 Item3 Subitem1 There are about 250 entries. I want to create a table with unique entries. SubItem1 SubItem2 Subitem3 Item1 YES No Yes Item2 No Yes Yes Item3 Yes Yes No Not sure how to use vlookup or Index/Match.
Solved by C. C. in 37 mins
If a cell in another sheet is populated I need a vlookup done. If the cell is not populated I need the cell to return blank.
Solved by T. D. in 60 mins
Hi, my VLOOKUP isn't working. No matter what I do it is returning the same result regardless of the sku it is searching for - even if I copy and paste the sky into the sheet the exact same way it is typed in the sheet its searching
Solved by X. H. in 20 mins