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!”
Here are some problems that our users have asked and received explanations on
I need a formula to copy a column from a spreadsheet to another, with a vlookup function
Solved by O. A. in 20 mins
VLOOKUP when the look up value is the output of a formula
Solved by V. J. in 18 mins
My workbook contains names (first and last) in the columns B8 to B38 on each worksheet. The worksheets are named Day1 to Day31 in the workbook. I am looking for a formula to highlight or isolate all the duplicate names across the workbook. Conditional formatting and Vlookup do not seem to help me much. I am new at excel and would appreciate your help.
Solved by A. L. in 29 mins
I am trying to figure out a VLOOKUP formula, returning a series name . I have a legend and code for the name...
Solved by I. B. in 12 mins
Hi I am needing help with another VLOOKUP formula that is returning a #NA. I have the file and instructions to look at. Thanks.
Solved by G. U. in 15 mins
I have a table with ID's and Names etc in a sheet and I have another sheet in which I need to enter data using the information in the table in the first sheet, like first name and last name, currency, pay rate etc etc. I am trying to use to Vlookup and Index Match functions but either I get an error or the cell just displays the formula and not the result .
Solved by M. D. in 29 mins
Formula question on sheet "Data" and VLOOKUP against columns in Function lookup sheet.
Solved by D. D. in 15 mins
After inputting your helpful formula in my spreadsheet, I found that there were a few other name formats that popped up. I have included them in this sample file. The top four work amazingly well, but the bottom group has a format unable to rearrange in the preferred format. Secondly, I find that there are some unwanted spaces that produces a #N/A or #REF return when executing a vlookup procedure. In some cases there are 1, 2 or even 3 extra spaces. I tried invoking a trim condition with no success. Thank you very much.
Solved by C. F. in 19 mins
I need an explanation for this formula:
=IF(G3="OnDemand",(VLOOKUP(CONCATENATE($B$1,C3,D3,E3," ","shared","hrs"),'AWS_8.1.17 Hardware'!B2:BT200000,11,FALSE))*730*J3*I3,IF($F3="Convertible No Upfront",(VLOOKUP(CONCATENATE(B$1,C3,D3,E3,H3,F3,"shared","hrs"),'AWS_8.1.17 Hardware'!B1:BR78560,11,FALSE)*730*J3),IF($F3="Standard No Upfront",(VLOOKUP(CONCATENATE(B$1,C3,D3,E3,H3,F3,"shared","hrs"),'AWS_8.1.17 Hardware'!B1:BR78560,11,FALSE)*730*J3),IF($F3="Standard All Upfront",(VLOOKUP(CONCATENATE(B$1,C3,D3,E3,H3,F3,"shared","quantity"),'AWS_8.1.17 Hardware'!B1:BR78560,11,FALSE)/12*J3)))))
Solved by G. D. in 26 mins
I need an excel formula to search entire workbook
Solved by B. H. in 19 mins