vlookup & if

I have a spreadsheet that pulls over data based on a code that we have created. So the current Vlookup says that if the cell comes back with a 0, then it will lookup the other code and pull back the name. I could get it to work one way, but not the other. Any suggestions...

Hi Everyone, I'm trying to create a simple lookup to search column B and D and fill Column C if column B and D matches. For example, since Column B and D value (106th Street Tires and Wheels) matches, I would like to fill the value of Column A (106STR) on Column C...

The iteration's value is the number of times I want to loop an action. This value is sent from a function, and for some reason, it is not looping as it should. Here's my working code. Function looking() Dim it As Integer Dim n1 As String, n2 As String, aCur As String, preV As String, rng As...

Create UDF to pass Return Value to iterate in For Loop I would like to use VLOOKUP or Array to perform math based on two cells, and use this return value as the number of time to iterate the For Loop. Do I send the two string value to the Function first, or in Sub sending to the Function? I...

I am trying to pull a list of equipment from a tasking list that reference an equipment code. On a seperate tab I have input a count in Cell F6 with: =COUNTIF('CP Board'!B1:B1999,"*PS") and starting in A2 I am trying to use : =IF(ROWS(A$2:A2)>F$1," ",INDEX('CP Board'!B$1:B$2000, SMALL(...

I’m looking to create a formula that will look at two separate columns [Status] and [Quarter] and select (for example) HP in column F and Q1 in column. Then add all those particular numbers located in the G column and add them. Example would be an outcome of all numbers added would have both...

Dear Excel experts, I'm experiencing some problems combining vlookp function with a IF statements. In fact the xls contains 2 worksheets:, 1 with an overview of different contractors/prices/.. for each part of a construction project and 1 worksheet with the retained/selected contractors based...

I have a workbook with 7 sheets containing part number of a product in column and its cost in adjacent column. And the 7th sheet contains total number of parts in all the sheets. I want to change cost of some products but then I have to do the same in all sheets. Is there a way by which it...

Hi guys, I have an issue with this for a couple of days actually.. I have to find in a certain date "column B" if User "column C" changes from the initial user´s number to another one to gave me the first half sales of the day and then obtain the other sales of the other part, this must...

=IF(ISNA(VLOOKUP(B9,$F$2:$F$15720,1,FALSE)) = TRUE, " ", D9) Buenos días, me uno a este foro porque estuve buscando solución a un problema que no logro resolver,ya busque en Internet y en este foro y no encontré algo que me pudiera ayudar por este post. Lo que pasa es lo siguiente: Tengo...

I am trying to use a VLOOKUP on a table of manufacturing die cuts of certain sizes. A formula tells me a number close to the die that is available. The rule is to use the next larger size die cut for the job. An example of die sizes are: Die Sizes 108.0 112.7 114.3 117.5 My formula gives me...

Hello, Excel semi-noob here, I have a vlookup issue that has been driving me crazy. I am working from a sheet (in workbook A) that has a list of usernames in column E. These usernames also exist in column B of Workbook B but they contain an extra five or six charactes at the end of the string...

I am trying to create a formula that will allow me to look at country and state in order to determine territory. I have on the first tab Country as column I and the state as G on the Vlookup tab I have country as column A, state as B and territory as C Ideally I want it to look at the country...

Hi, trying to work a formula to look up a value in a colum that has multiple entries of the vale based on the value of another column. My value is in cell A2 (value = 1234567). The value is shown in Sheet1 in column A along with responding data in columns B & C. My value however is duplicated...

Hi there, Is anybody aware of an option to use e. g. in a vlookup a reference to a cell in the “source sheet” instead of the sheet name? I have quite some sheets w/ similar data sets – which I due to various reasons cannot combine in one sheet. E. g. in column A of the consolidation sheet...

I am not sure how to even word this title, so if someone comes up with a better Title example, please let me know and I'll edit it. I'm a semi-advanced Excel user in that I have taught some Excel classes (on shortcuts, pivot tables, excel formulas - basic and intermediate) but I'm not so...

Hi I am working on this problem in excel. Any recommendations will be appreciated I want to transform data from Format 1 to Format 2 in attached sheet. Format 1 Column A: Customer Group is at 2 levels CBP and Target. One CBP can have multiple targets. One target can fall in only one CBP...

Hi all, so here's the problem. I have an excel sheet with multiple columns. In one column I have X's and in another I have a limit. I need to look down the stuff column, find every X, match each X to its corresponding limit and then compare all the limits and return only the smallest limit...

Hello, I want cells that are >=6 to be have a "P" instead in a different worksheet 3-5 to have a "F" instead in a different worksheet <=2 to have a "G" instead in a different worksheet But in my worksheet I have 0 and blank cells. I need the 0 to say "G" and the blanks to remain blank. I...

I have initial data in Worksheet 1. Each row has a specified status (Submitted or Outstanding). I'd like Worksheet 2 to self populate with certain data from only the rows that are marked as Submitted. I'd like Worksheet 3 to self populate with certain data from only the rows that are marked as...