Get instant live Excel expert help with VLOOKUP functions

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.

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

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?

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

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.

Trying to use a vlookup sheets and pull data over from another sheet on the same file.

I would like to make a table from drop down list with vlookup function

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

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.

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.