Get instant live Excel expert help with VLOOKUP functions

“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

Hey there - I am trying to populate a sheet using data on another sheet, and I want to populate it by a certain number on the second sheet. I.e., I have a row of an address, and I need that address to populate 11 times, and 11 is a sum of an existing formula on a secondary sheet. I'm stuck somewhere between VLOOKUP, Array formulas and Macros.
Solved by M. W. in 12 mins
I have a spreadsheet created. However, I need the formula to work off of text too, not just a number. This is my formula: =IF(AND(K5>0,L5>0,M5>0),ROUND(VLOOKUP(TEXT(K5,"00.000")&TEXT(L5,"0.000"),'Shape, Support Tooling'!A2:G19,5+M5,FALSE),0),"") Where M5 is, is where I would need the column to have words in it instead of going off numbers
Solved by E. U. in 12 mins
I am trying to fill small tables from a master data table, I am trying to use the vlookup but it doesn't seem to work as well for this as I thought it would. Could you take a look at this file and see if you have any suggestions?
Solved by Z. W. in 12 mins
I manage a few accounts in adwords. I am trying to create a visual budget tracker that shows for different accounts the spent up to now from the beginning of month, and the spend today and yesterday. The idea is to drop the raw data and automate its tracking, I managed to do it for totals, but not for spent yesterday or today. Tried with vlookup and match but maybe I am doing it wrong
Solved by E. H. in 21 mins
Trying to set up a selection process for products. Each product has certain accessories and the choice of accessory can limit what other accessories can go with that configuration. I am trying to use INDIRECT, VLOOKUP combinations, but if there is a better way, I would like to know.
Solved by Z. Y. in 20 mins
Trying to use a vlookup sheets and pull data over from another sheet on the same file.
Solved by G. H. in 17 mins
I would like to make a table from drop down list with vlookup function
Solved by C. Q. in 15 mins
Hi, I have a spreadsheet with a Summary tab, tabs for Jan-Dec, then a customer information tab. On the monthly tab is a list of every invoice for the month with a VLOOKUP to add the account managers name in once the customer name is typed. I want to make a formula on the summary page for the sum of the monthly sales for each account manager but it keeps coming up with errors. I'm not sure if this is because I'm putting if the cell with the VLOOKUP already in = the account handlers name and it's not picking it up because it doesn't have their name it has the formula? Sorry, I'm not that clued up on Excel - this is probably (hopefully) a quick, easy formula! Thanks
Solved by C. S. in 20 mins
I have a data base in excel using VLOOKUP. A drop down list looks for data in another sheet and displays it on my data sheet. One of these cell's on my data sheet (say A1) looks at data in cell M2 on the other sheet. What I would like to do is enter data in A1 on my data sheet so that it will be entered on M2 on the other sheet but will still be displayed when the drop down list requests it.
Solved by E. H. in 20 mins
I am trying to use a filter function (possibly in conjunction with vlookup or index) in order to match a name submitted via a google form to a roster on a separate sheet. It also needs to be able to pull in select cells from the form response sheet to the roster on the secondary sheet based on the name submitted.
Solved by G. F. in 20 mins