Hate to bump, but I'm stuck.....
I posted Friday, but with 56 views, I'm the only post without a reply through Sunday, so I'll try to parse my inquiry.
VLOOKUP Macro Workbook Reference Variable
Range("J2").FormulaR1C1 = _
"=IFNA(VLOOKUP(RC[-5],[" & wkb3 & "]!C5:C9,5,0),"""")"...
I'm in a worksheet and trying to extract the words after the 3rd and 4th hyphens when they're available in column A (see table below for representation).
Digital - workbook - sheet
Digital - workbook - app
Digital - workbook - test
Digital - workbook - sheet - max - version1...
I am trying to use Index Match to replace Vlookup Function so my textbox displays date format. If I use Vlookup my textbox shows numbers. I tried the below code but it is not displaying the value in the textbox once I run the code. Can I please have your help to make the code work?
Dim TBL As...
Hello Guys. Please help me with my little Project.
I have this project where i needed to link a database(Process2.excel) to another database(Process1.excel) so that it can automatically compute the offset adjustment(CNC Machinining) based from the Part ID's data from the previous process. The...
ive created this formula and it works perfect, but as your see in a sec its rather big.
Can anyone think of a smarter way to get the same result.
The below checks to see if there is a date in the BOLDED cell and if there is it moved onto the next till it cant find a date, when it cant...
Hi I am trying to consolidate multiple sheets into 1 tab. I don't know how to use the sumif because 2 of my criteria are in the same column: the customer name and the value name. I don't even know exactly what formula to use...all help would be appreciated. I am trying to consolidate data in...
Running a very basic test code to try out on a large amount of data, but having trouble, getting the "1004" error.
Dim c As Integer
'LOOPS THROUGH ALL ROWS
For c = 2 To 10
If IsEmpty(ActiveSheet.Cells(c, 1)) = False Then
ActiveSheet.Cells(c, 2) =...
Im looking for a VBA code that works like Vlookup.
Lookup data= A:B
(D1) is a dropdown list of A:A
(E1) is a manual input of a number.
When the Macro is ran, I want it to search for (D1) in column A:A and increase the amount in the corresponding B:B column by the amount in (E1).
Hello. I have a vlookup function looking up American citys/towns and returning the full state name that they are located in. How can I pull in the full state's name (how the data comes in), but then have it display the abbreviated state's name. Example: Florida -> FL. LEN( doesn't always...
I have a multidimensional array with 'x' rows and 3 columns of data, and I'd like to perform a VLOOKUP on the array information stored in memory rather than calling the worksheet each time. I'm just not sure how to write the code to perform the VLOOKUP using INDEX/MATCH, and repeat that process...
I have a table of courses with the name of the student. Then I have another table that I am trying to get a Yes or No value based on if they took the class. I believe I need a vlookup function, but I am missing how to get that data.
Tom Smith Math 101
So, I have a list of Yes/No questions and what I am trying to do is create a string of the terms that have a Y beside them. For example in the data below, I would like the cell to return Agitated, Angry, Depressed and I will reference that in a different part of a sheet. I would like for this...
I have a column that has 1,000 rows in it. Each cell in the column has a VLOOKUP function in it. When I search in that column I get an error telling me it can't find what I'm looking for. For example if "Sales" was the result of one of the VLOOKUPS in the column and I do a Control F and...
i have a unique problem I cannot find a solution for. Need help,
I have a tabel where the first column is a VLOOKUP column from a list of names. Subsequent columns are input data with no formulas.
Now, If I add a name to the name list, it shows up in the first column, but, obviously...
Hi Great minds.
I have a file with 2 sheets
Values for example:
If we input a code from sheet 1 to sheet 2 manually, we would like to get the following result...
I am in a major pickle at the moment :eeek: Help!
I would like the formula to find the pricing across multiple tabs and the problem is the pricing column.
The pricing column is situated on a different column letter and row number on each tab:
Please see the link below for the...
I have a list of prices, products, customers, etc. that are in categories (Beef, Chicken, etc.) and in subsets (Salisbury, Ground, Raw, etc.).
I am using the Aggregate function to determine the lowest price.
Then, I use the VLOOKUP function to search that lowest price for who is purchasing...
Which is faster?
I have two workbooks. One has all the personnel information and the other has equipment information. They team up to create picking sheets for the warehouse. Each provides information to the other one via vlookups.
I was wondering if instead of doing a vlookup I could simply...
I have a table that has a list of requirements from various documents. The table is called "Combined_Req". Each requirement is assigned a unique identifier "ID", that is in the form of "CR-1", "CR-2", etc."
I have another table called "Req_by_Category" where I have consolidated like...
I am trying to use a tab name as part of a VLOOKUP formula however what I have so far returns #N/A
=VLOOKUP(U5,'SCORING BY MONTH'!A4:B203,2,FALSE)
And in cell U5 I have the following:
In this instance this...