Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Find Value In Table Based On Value In Row & Column

I have a table where the columns are named: A, B, C, D and E and the lines are named: 1,2,3,4 and 5. All the cells of this table are filled with values.
I want the function to return the value on the correspondent cell everytime I type a combination of column and line. For instance if I type "B2" the function would return the value on this position...

Actually I am looking for something like a combination of the functions "hlookup" and "vlookup"...

View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Find A Value In A Table Based On Other Criteria
I'm trying to find a suitable formula that looks at two cells (J3 and V3) in Sheet 1 (a person's employment grade (e.g. 18) and their performance percentage e.g. 92.5%), finds those values in a table on Sheet 2 and then places the corresponding value from that table in Sheet 1 at cell Z3.

View Replies!   View Related
Find Value In Table & Return Column / Row Header
I am having trouble with getting a value (which is the row and column value) from a set of numbers. I have attached an example table to try and make things clearer.
What I have is a table with a set of Row Headers, and Columns Headers all numeric. e.g Columns headed 1, 2, 3, 4, Rows 30, 40, 50 etc. I want to find the 1st occurrence of a value e.g. 1.0 in the table (by 1st Up mean closest to top left), and then give me the value of the Row and Column Header that corresponds to that.

So for the example attached, I want to get the row Value 200 and Column 6 from finding the 1st occurrence of the number 1. I have tried various combinations of index and Match etc. But I can't get my head around the fact that the position of the 1st no. 1.0 can change, therefore I can't use any releative positions etc.

View Replies!   View Related
Pivot Table Fields, Based On Column References
I have a pivot table which draws data automatically from a database

What I would like it for the customer field of the pivot table to only equal the customers which are present in another worksheet (Column A:A)

View Replies!   View Related
Fill Table Based On An Drop-Down Choice In 1st Column
I'm working on making a spreadsheet that allows me to select an item type from a dropdown list (through validation) and then would copy in a range of values from another worksheet based on my dropdown selection.

The set-up: I am primarily concerned with two sheets in my workbook, BiS and Weights. I have a database of items and their associated values listed in Weights. I have already managed to get dropdown lists of my specific item types using named lists and have put that in the BiS worksheet.

What I would like to do is have the values in the Weights worksheet copied over in the same order and number of cells based on what item I select from the dropdown list.

View Replies!   View Related
Pull Found Records From Table Based On Single Column
I have the following data :-

COL A_______COL B________COL C

COL A_______COL B________COL C

I need to search data from range defined A1.C3 and if any data in that range found in the sheet 2 that having the same records.

View Replies!   View Related
Copy Data Table Seperate Sheets Based On Column Criteria
I need to copy all the work sheets into one single work sheet (mastersheet). The source work sheets are having same column structure. The condition which i need to take care of is that after column 3 if at all there is any data till column 10 then in the destination mastersheet these should be copied in different rows with first two columns repeated. I need to do this using VBA macro.

View Replies!   View Related
Find Cell Based On Column And Row
I have a spreadsheet which has about 100 different SKUs in column A and the inventory for each SKU by period in columns B:Z
So for example B would be P1W1 and C would be P2W2, etc

what kind of lookup function would I use in VBA to find per say, the value of SKU #: "27017" in P1W2 ?

Apart from pivot table.

View Replies!   View Related
Find Records Based On More Than One Column
I have a very large table that has a one to multiple relationship in a GIS. GIS doesnt support that type of relation ship. I need to find records that are related to the single key but have different values than the first record for that key.


Col 1 col 2 Col 3(key)
ab ab 1
bc bc 1

In this example, only the first row (ab) will be regarded in the GIS. so I need to pull out the second row and put it into another dbf based on the three columns so that I can then put it into the GIS so that the second row is considered and not ignored.

View Replies!   View Related
Find Top5 Or Top10 Or As Required Based On A Value In A Column
I need to find out Top 5/Top 10 or as required based on two columns. I have clearly explained the way it is required in the attached sheet.

View Replies!   View Related
Find Columns By Name And Highlight Them Certain Colors Based On Text In Another Column
I have a worksheet with 20+ columns. For this macro, I only need to focus on 4 of them. However, none of these columns are ever in a fixed position so the macro would need to find them by name and NOT by column position. Here they are...

1. Vacation Type (will only have a text value of either "Cold" or "Warm")

2. Vacation Started (will always have a date *x/xx/xxxx)

3. Vacation Ended (sometimes it will have a date '*x/xx/xxxx' and sometimes it will NOT have a date and will be truly blank)

4. Number of Days (currently has ALL truly blank cells)


Here's what I would like the macro to do...

Scenario 1 - for "Cold" values
Find "Cold" text values in the "Vacation Type" column
"Cold" values WITH a date in the "Vacation Ended" columnIF there IS a date in the "Vacation Ended" column in the same row, put the number of days difference between the "Vacation Started" column and "Vacation Ended" column in the "Number of Days" column.

The amount of days in the "Number of Days" column will determine whether these cells should be highlighted GREY or RED.

A) IF the number of days difference is 7 days or less, highlight the cells in the "Vacation Ended" column and "Number of Days" column RED.

View Replies!   View Related
Find Highest No. In A Column But Inclusion Is Based On Data In Other Cells
I’m keeping tabs of some clay pigeon shooting scores. I go to alternate locations each week and normally shoot 100 clays, however sometimes it’s only 50. I’ve used MAX to find the highest score in Column D of a spreadsheet and it did what I required. However I now wish to find the highest number in Column D - but only include rows if Column C = P and column E =100.

Col B Col C Col D Col E Col F
date Location score out of % hit


In other words I want to find the highest score for location P but only if that week it was out of 100 shots. It would return 66. Then I can do the same formula for location A and it would return 62. I can’t see how to do this and have searched the forum to no avail. It doesn’t look like I can just use the MAX anymore and I’ve tried incorporating that into a (nested) IF but unsuccessfully.

View Replies!   View Related
Find Largest Invoice For Each Individual Identifying Code Number In The Table Without Using A Pivot Table
Data Table including-

List of Identifying Code Numbers for customer invoices

Multiple repetitions of individual Identifying Code Numbers in list

Various data in table range including Various Values of invoices from different dates for each repetion of Identifying Code Number.

- Wish to find largest invoice for each Individual Identifying Code Number in the table without using a pivot table.

i have tried combining Max and Large functions with Vlookups etc.

View Replies!   View Related
Index/Match: Match Column "G" To Column "L" And Count Column "H" Based On The Table To The Right
I am having a little trouble with tying an index/match formula that would probably require an "if" portion to the formula as well.

If you take a look at the attachment, I'm trying to match column "G" to column "L" and then use the appropriate price according to the specified piece count in column "H" based on the table to the right.

View Replies!   View Related
Create Database Table From Multi-Column Summary Table
I want to accomplish something like this but slightly different:


I have the same issue but a bit more complex. In my case I have an additional amount of columns (let's say dimensions). So for the example given (sales per month) I would add two columns for 4 different regions and 5 machine types (just examples).

The output (that would serve as pivot tabel input) would then have to be a 4 x 5 x 12 x 4 = 960 row database table.

I have tried to accomplish it by customizing the given code but that provedto be beyond my powers ;o)

and some 3rd party software [url]and [url] but non of them is doing what I'm looking for.

The code I'm looking for ideally would count the number of columns and unique records per column and construct the database table from that. So I am looking for flexibility in the number of dimensions also...

View Replies!   View Related
Fill Table By Match Row & Column Headings Of Another Table
I currently have a table with a range of headings (row & column), and the necessary data for it. On a new worksheet, I have a table with only a few of the headings, and I was wondering if there was a macro that would automaticlly match the headings of the new sheet with the other table, and fill in the ncessary dat, as on the other sheet.

View Replies!   View Related
Creating A Mat Table Based On A Price Table
Part 1: Pricelist
The user presses 1 of 3 macro buttons to access the price list.
The buttons represent 1 of 3 parts of a construction project.
The buttons are labeled PHASE 1, PHASE 2 & PHASE 3. The macro,
depending on which button is pressed, hides all but the relevent quantity
col & total col.

Each job phase needs its own total & having it setup this way makes it
easier to enter new items into the table (only have to enter
the item once, rather than 3 times).

The first html shows a simplied example of the "price list" described above
(before & after the quantitiy & price cols are hidden).
The user adjust the quantity & the sheet calculates the price total.
Part 1: Material listThe material list is a list of items & quantities the user selected in the
quantity col of Price list. This list is to be printed & given to the workers.
It does not show price, only item & quantity.

This list, unlike pricelist, must be visiablly broken down by job phase.

I dont want the material list to be the price list repeated vertically
on a sheet 3 times. This would take up too much space & require new
items to be entered once in the pricelist & then 3 times in the mat list.

I would rather the mat list be on a seperate sheet from price list & have
a formula in cell matlistA1 that searches the phase 1 quantity col
(then phase2 & 3) for the first #>0.

When a #>0 is found, the formula
would return an item name into the cell on matlist. Then the formula
would run in matlistA2, & search for the next #>0.
(& so on until a complete mat list table, broken up into phases is created)


ABCDEFGHIJK2 3 4 PRICE CALCULATOR (USED TO ESTIMATE ANY OR ALL 3 PHASES OF CONSTRUCTION) 5 6 7 *this is how table appears before macro button named job PHASE 1-3 is pressed to access. Macro hides 2 of 3 quantity cols & 2 of 3 total cols. 8 9 10 11MATERIALSQUANTITY PRICE TOTAL12MISCELLANEOUS PHASE 1PHASE 2PHASE 3 PHASE 1PHASE 2PHASE 31399871009'x12' PLASTIC DROP CLOTH1 X4.73=4.73

View Replies!   View Related
Fill Table Based On Corresponding Table & Being Between 2 Dates
I have an 'existing results table' as per my attached sample. From this table I need to create a list of 'sold' for each annual date range - i.e. I need a separate list for items sold within that date range. see my example in red. *Note. I am working with Excel07 however my attached sample is in Excel03 because I couldn't upload an XLSX file.

View Replies!   View Related
2 Column Horizontal List To Multi-Column Table
I am trying to create a macro that converts a large list of Customer details from a vertical to horizontal format.

Each Customer has a unique sequential number running from 1 but the details are not always the same (e.g. in the below Phone does not always appear).

Current format is per the below:


Column A Column B

Address ABC
Phone 1234
Amount 25
Address XYZ
Amount 500
Address PQRS
Phone 567

Format afterwards should be

Customer AmountAddress 1Phone
1 ABC 1234
2 25 XYZ
3 500PQRS 567

View Replies!   View Related
Find Rows W/same Value In Column A And B And Offset Column C To Next Available Column
I need to combine rows that have the same value in column a and column b to the same row by offsetting column c to the next available column. For example, I would like the first 6 rows of the provided sample to appear like this.

0014B22<@44>Soil Properties and Qualities<@44>Soil Properties and Qualities<@44>Soil Properties and Qualities

Sometimes the values are the same in column c, sometimes they are different. I do not want to delete duplicate rows where they are the same. Sometimes there are 2 rows that have the same values in column a and column b, other times there may be 3 or even 4 rows with the same values in column a and column b. Regardless, I would like the values in column c combined on the same row in the next available column. It would be nice if the duplicate column a and column b rows (with a null column c cell) were then removed, but I could do that in the next step.

0014B22<@44>Soil Properties and Qualities
0014B22<@44>Soil Properties and Qualities
0014B22<@44>Soil Properties and Qualities
0014B24<@33><i>Available water capacity:<p> High (about 11.5 inches)
0014B24<@33><i>Available water capacity:<p> Very low (about 2.9 inches)
0014B24<@33><i>Available water capacity:<p> High (about 9.0 inches)
0014B25<@33><i>Slowest saturated hydraulic conductivity:<p> Moderately high (about 0.57 in/hr)
0014B25<@33><i>Slowest saturated hydraulic conductivity:<p> High (about 1.98 in/hr)
0014B25<@33><i>Slowest saturated hydraulic conductivity:<p> Moderately high (about 0.57 in/hr)
0014B26<@33><i>Depth class:<p> Very deep (more than 60 inches)
0014B26<@33><i>Depth class:<p> Very deep (more than 60 inches)
0014B26<@33><i>Depth class:<p> Very deep (more than 60 inches)
0014B27<@33><i>Depth to root-restrictive feature:<p> More than 60 inches
0014B27<@33><i>Depth to root-restrictive feature:<p> More than 60 inches..............

View Replies!   View Related
Find Value From Other Table
What formula should I use to find values in Table 2 from Table 1.

Table 1

Acct# Value

100000 12
180250 9
180300 9
180450 9
181854 15
181860 11

Table 2

180250 ?
180300 ?
181860 ?
100000 ?
180250 ?
181860 ?

View Replies!   View Related
Searching A Table To Find A Value
I have one sheet (sheet 2) that contains three columns of data, a range of a low value and a high value and a corresponding value (column c)--
0 54 0
55 64 1
on the other sheet(sheet 1), i have a column(column x) in which i need to find that corresponding value (that column c on sheet 2). basically, i need to write a function that says if value x (on sheet 1, column y) is between the values in columns A and B (on sheet 2), input the corresponding C cloumn value (on sheet 2) into column x on sheet 1. i hope this makes sense. an additional snag is that i have about 60 rows on sheet 2, and i need to make it keep searching this table until it finds the range that contains my value x (on sheet 1).

View Replies!   View Related
Find Data In One Table From Another
I need a formula that will allow me to search a column (B1:B19989) that
contains text with the data from a column (A1:A32417) that contains a list of
part numbers and display a result(True/False) into another column (C). Column
B's text has the part numbers mixed in with the text. I need to know which
numbers from column A are found within the text of column B.

This is what I have tried in C1: =VLOOKUP(A1,CATALOG,2)

All I get is #N/A - I know that the value in A1 exists in CATALOG

CATALOG=The name of array B1:B19989

View Replies!   View Related
Multiply Every Nth Cell By Another Column Whith Merged Cells, THEN Find Column Total
Please see the attached sheet. I have columns B through a lot (B through O in my oversimplified example). In every 7th row in each of these columns there is either a 1 or a blank/zero. I need to multiply that 7th number by the Quantity in column A, to achieve a total (ie the sum of each result of 7th cell*quantity) for each column in the bottom row, labeled "Totals".

In the actual version of my sheet, there are far too many rows to select everything manually. I've been fiddling with combinations of COUNTIF/COUNTA and OFFSET, but I haven't come up with a way to check for the 1 in every 7th row, THEN multiply that 1 by the quantity in column A, THEN add up the results for each column. As you can see, there are 1's elsewhere in the columns that are irrelevant to this particular calculation, so something like LOOKUP would also have to look in every 7th cell and couldn't just look at the column as a whole.

If you can't provide an immediate solution, but can at least point me to a resource that would allow me to devise a way to isolate every 7th row (THAT part is the sticking point), I'll surely post the solution to my own thread with updated keywords if I need it.

View Replies!   View Related
Find Duplicates In Column A And Calculate Difference Between Times In Column B
I love this forum, and am usually able to find the help I need without bothering anyone However this one has me stumped and I wonder if anyone can help. It feels like it should be a fairly simple solution, but they can often be the ones that are most eluding LOL!

I have two columns; in column A are incoming telephone numbers and in column B are the date and time the calls were made. (I've put a few hashes in column A just to maintain confidentiality of the numbers, but in reality the cell is formatted as text in order to maintain the leading zero, and entries will follow the format 01234567890)

A sample would look like this:

0##6270####01-Mar-2009 00:01:440##6271####01-Mar-2009 00:03:020##6271####01-Mar-2009 00:03:040##6272####01-Mar-2009 00:16:330##6273####01-Mar-2009 00:30:490##6274####01-Mar-2009 00:55:470##6274####01-Mar-2009 01:06:170##6274####01-Mar-2009 01:07:420##6275####01-Mar-2009 01:08:360##6275####01-Mar-2009 01:11:410##6276####01-Mar-2009 01:13:45

Some numbers only call in once, I need to identify them as only called once.

Some numbers call twice, if they do I need to be able to show time it took between call 1 and call 2.

Some numbers call more than twice. For each successive call I need to be able to show the time since the previous call.

In my mind, the results table would need to look something like this:

NumberTime of callTime between
1st and 2nd call
Time between
2nd and 3rd call
Time between
3rd and 4th call
0##6270####01-Mar-2009 00:01:44Only called once0##6271####01-Mar-2009 00:03:0200:00:020##6272####01-Mar-2009 00:16:33Only called once0##6273####01-Mar-2009 00:30:49Only called once0##6274####01-Mar-2009 00:55:4700:10:3000:01:250##6275####01-Mar-2009 01:08:3600:03:050##6276####01-Mar-2009 01:13:45Only called once

View Replies!   View Related
Code Change Below To Find The Customer Column By Name Rather Than Column Letter
I have this macro below and would like the code changed to find the "Customer Number" column by name rather than by column B. Note that the "Customer Number" column will always be somewhere in row 1.

View Replies!   View Related
Find The Column Name Purple & Delete The Whole Column If There Are No Blank Cells
I'd like a macro that does 3 things..

1. Find the last row (cell) of data in the "Customer Number" column. This search should be by the name "Customer Number" rather than by column letter because the column that "Customer Number" will be in can change.

2. Find the column named "Purple" (also by name for same reason)

3. If the "Purple" column has no blank cells in those same number of rows as the "Customer Number" column, delete the whole "Purple" column.

View Replies!   View Related
MINIF Function; Find The Minimum Value Of Column A If There Is Anything Greater Than Zero In Column B
I want to find the minimum value of column A if there is anything greater than zero in column B. I tried this formula (simplified): MINIF(B2:B6,">"&0,A2:A6) And it gives me the # NAME? error

View Replies!   View Related
Find Last Col In Open-ended Table, Then Sum
I have a worksheet called Sales that could contain any number of columns of data. On another worksheet, I would like to find the last two columns and use a formula like:

Sumif('Sales'!C:C, c5, 'Sales'!D:D). (I have Excel 2007 so D:D is good)

The problem is how to change the C:C and D:D part to be the last columns.

I'm looking for something simple like this:

Sumif('Sales'!Secondtolastcol:Secondtolastcol, c5, 'Sales'!Lastcol:Lastcol)

View Replies!   View Related
Find The Cheepest Provider In A Table
I must have gone into a complete "blackout" as I am stuck with something that seems to be more than simple.

In cell F18 I need a NON Array-formula in order to return the cheapest Provider for a given Country [to be selected via D.V. in cell F14].

I manged to find an Array formula which I left in a broken state in cells F6-->H6/

View Replies!   View Related
Find In Table, Then Concatenate Results
My data is pulled in as a table from QuickBooks, so its many rows consisting of many column entries per row. The columns are laid out like:


I currently have a SUMIFS formula that works well for searching the table and finding PO's that are not paid, for a specific vendor, on a day today or before, and it ads the amounts together and returns the sum opf the amounts for me.

Now, what I would also like to do is to have it return the PO numbers as a concatenated text string all into one cell. So, it shoudl find all the rows where the due date is today or before, the PO has not been paid, and the vendor is a specific vendor, and then concatenate all of the PO numbers into one cell of my choosing.

This sounds just like the SUMIFS function, however, the SUMIFS function adds the values and places the sum in the cell of my choosing. For this, I would like the values found (which are text values) to be concatenated into one cell.

View Replies!   View Related
Find Cell Address Within A Table
Does anyone know the formula that produces the address (e.g. $A$1) of a cell within a table? I found the formula that gives the address of a single cell within a single row (or the address of a single cell within a single column). But I need the formula that gives the address of a cell where the row intersects the column. If I know the column header name and the row header name, how do I find the cell address for the two dimensional intersection?

View Replies!   View Related
Find Source Of A Pivot Table
How can I possibly find the source path of a file used to build a pivot table. So basically the pivot table is using an external source and I'm unable to find it.

View Replies!   View Related
Find Unique Value In Lookup Table
Index Match lookup formula does not find valid entries that exist in the lookup table. Formula: =INDEX(tbl_Costs,MATCH( F8,tbl_Costs_PN,0),MATCH("Cost",tbl_Costs_hdngs,0)). I've verified that the matching criteria and values are, in fact, in the table and have made double sure that all cells are formatted the same. the attached file and show me the error of my ways.

View Replies!   View Related
Trying To Find Max Date In 1 Column For Selected Text In Another Column
I have 2 columns: Locations (Column A) & Dates (Column B).

I want to find the most recent date for a selected Location (stored in $G$1).

currently I have in C2: =If($A2=$G$1,$B2,"") copied down the column to the end of data (currently C153). Then in C1: =Max(C$2:C$153).

I also have in D2: =If($C2<$C$1,$C2,"") copied down to D153, and in D1: =Max(D$2:D$153) to find the 2nd most recent date.

Is there some way to condense this into just 2 cells?

See attached file for example (note the columns are currently sorted by date, but that is not always the case).

View Replies!   View Related
Macro To Find End Of Column And Paste Contents In Column 1
I have the file here i work with, basically the first column is a legend and the column to the right of it is a pointer column to help me find out where a legend is located in another file. So i was wondering if a macro could be made to basically find where the "legend column" A, C, E ect ends ( every other column is a legend column , one next to it is a pointer column ). and then combine the ends all of the columns contents and put them into 1 column.

In the file with this question i have showed you what i start off with, i highlighed in yellow where each column legend ends, ( normally these are not highlighted and i find them manually ). In the 2nd tab i show what the end result should be. All the columns are now consolidated into 1 column. 1 after the other.

View Replies!   View Related
VLookup/Index (round-down E3 And Find Its Corresponding Row In The Table To The Right)?
I need a formula for F3 that will round-down E3 and find its corresponding row in the table to the right and find its intersection with the coating listed in I3. Does that make sense?

I've tried, to no avail:

View Replies!   View Related
VLOOKUP With MATCH To Find Data In A Table
I'm using VLOOKUP with MATCH to find data in a table. I now have to add a third condition to the look up. I've attahced a file as an example. I'm not sure how to list the data for the third condtion. I created another table with the data for third condition.

View Replies!   View Related
Using Find In Macro To Select Range Of A Table
I am trying to find a table of text, and copy it to another worksheet. I want to copy it as a range, not as rows or columns. Using Find, I can get to the 1st row of the table. Using Find again, I can get to the last row of the table.

What I don’t know how to do next is select the range.

For example; The table is in cells A10:F20. “Start” is in cell A10, and “End” is in cell A20.

Starting from cell A1, how do I find and select the range A10:F20.?

I will be doing this twice in the same macro, as there are 2 tables. Each of the 2 tables has the same “Start” and “End” text, as described above. The 2 tables will not always be located in the same location within the original WkSht.

View Replies!   View Related
Find Out The Source Data From A Pivot Table?
I've got a bit of a problem revealing pivot table source data, so just wondering if anyone know how to reveal it? My colleague sent me the spreadsheet, I can see the pivot table, but I can't find the source data that the pivot table links to.

View Replies!   View Related
Find Text In Cell (search Whole Table)
I am having a littler trouble with using a function to find text (last name) in a table and then return full name from the table. See attached sheet with example of what I am looking for.

A quick explanation:

Have a table with columns that have team and name of player. My input is the last name of the player and the team. Need a fomula that searches all the table and then returns the full name of player based on 2 conditions of last name and team.

View Replies!   View Related
Find Each List Value In Table & Copy Corresponding Range
Hopefully someone can help me and understand what I am trying to do. I'm almost finished my project and stuck on one last part! If I have missed a similiar example on the forum could someone point me to it

I have a list of Lines (a,b...) which start at point i and end at point j.
Line i j Point x y
a 1 2 1 6 10
b 2 3 2 7 4
3 2 3

I have have a seperate list of the points. Each i point and j point have x and y coordinates.
I want to find the i point value in my list of points and copy the following two columns (the x and y values) to Sheet2. On sheet2 I want to paste the i values in row 1 and the j values in row 2, skip two lines and move onto Line b.

View Replies!   View Related
Find Value On Row & Find Last Used Column Before Found Value
Dim ColNo As Byte
Dim LastCol As Byte

ColNo = Application.WorksheetFunction.Match("Column find", Range("sheet1!A1:Z1"), 0)
LastCol = Range("sheet1!b1").End(xlToRight).Column

But the below code errors?

Dim ColNo As Byte
Dim LastCol As Byte

ColNo = Application.WorksheetFunction.Match("Column find", Range("sheet1!A1:Z1"), 0)
LastCol = Range(Cells(1, ColNo)).End(xlToRight).Column

View Replies!   View Related
Find Duplicate Table But With The Numbers In Each Of The Cells Doubled
I have a table that is 94 columns *12 rows each cell has a different number I need to find a way to duplicate the table but with the numbers in each of the cells doubled.

View Replies!   View Related
X Condition Lookup: Find The Specific Value Within The Table Or Array
Given three criteria (category, name and date) I want to find the specific value within the table or array. refer to attachment.

View Replies!   View Related
VBA Find First Populated Column In A Row, Starting At Column X
How would I write something that finds the first populated column in a row, starting at column C and moving to the right?

View Replies!   View Related
Find Value In Column & Return Cell On Same Row- Different Column
I have an excel sheet I am working on and in columns F1:F2000 I have an IF statment, I need to be able to add more "IF"s to it but I will exceed the 1024 char limit. Is there a way I can put this formula into VB as a function called DocumentType() and then in excel F1:F2000 =DocumentType()?

Is it as simple as:

Function DocumentType()


End Function

View Replies!   View Related
Find Value In Column And Return Value From Adjacent Column
I have are two worksheets, "Sheet 1" which is a bill of lading form and "Sheet 2," in which columns A and B contain Part Numbers and Weights respectively.

What I'm wanting to have happen is when a user inputs a part number into Sheet 1 (say in cell B6), it calls a UDF that looks up the part number on sheet two column A and returns the corresponding weight from column B (to say cell C6 on sheet 1).

View Replies!   View Related
Find Data In 1 Column Transfer To 2nd Column
I have a spreadsheet (XL2003) that calculates some price data based on a specific algorithm. The program then determines which price data meets a certain criteria and if met, will place the value in a column ( Column C in the example WS attached.) If criteria not met the cell is returned empty. Under certain settings, this column could have values in all rows (C9 to C27 in the example) but is usually just a specific consecutive list as in the example.

I have to transfer the calculated values to another spreadsheet so I want just these values to be initially transferred to a separate column (Col. H in the example WS.) from which they can easily be transferred later to the other spreadsheet. I need to figure a way for a macro to check in col. C (ie C9) and if there is a value in the cell, to transfer it to the next available cell in Col H (Starting with H9). The macro would then look at the next cell down in Col C (C10) and do the same routine until the last cell is reached. The transferred data would then end up in consecutive cells in Col. H. I have shown in the example attached how I would want the data to look after the macro is run. I figured this is some type of loop but could not see any examples in the forum that would do what I need.

View Replies!   View Related
Merge Two Workbooks. Copy Column Data Based On Numerical ID Match Of Another Column.
I am trying to get excel to search a workbook/(or worksheet if easier) for a matching unique value and fill in its associated data. My first workbook has the SKU (A) filled in but not the UPC (B). My second workbook has both the SKU (A) and the matching UPC (C) filled in.

I need to take both workbooks/(worksheets), compare the SKUs, and if a matching SKU is found, extract the UPC from Workbook 2 and fill in the UPC field in Workbook 1, and if no UPC is present in Workbook 2, then it leaves the cell in Workbook 1 blank.

View Replies!   View Related
Range Object/property: Calculates 2nd Column Based On 3rd Column's Number
I'm trying to write a code that calculates 2nd column based on 3rd column's number or vice versa based on the condition set on the 1st column. Below, there are two procedures. "SimpleCalc" and "SimpleCalc2". I first wrote SimpleCalc2, but it isn't working, so I worked around the error by writing SimpleCalc, which selects a cell and moves around by offset. I personally find it hard to read and error prone as I develop more logic around it.

I'm trying to develop more function based on this code, so I need to make it neat and flexible. what I'm doing wrong in SimpleCalc2? Or do you have any suggestion to improve the code "SimpleCalc"? I'm using Excel 2003.

Sub SimpleCalc()

Dim SimpleMethodRng, SimpleMethod As String, i As Integer


SimpleMethodRng = ActiveWorkbook.Worksheets("Dashboard").Range("N5:P12")

For i = 1 To 8

SimpleMethod = SimpleMethodRng(i, 1).........

View Replies!   View Related
Copyright © 2005-08, All rights reserved