Search A Column & Return Many Results
I have a workbook with two worksheets.
On Sheet1 I have two columns 'Date' & 'Serial Number'
I want to search the 'Date' column for entries that contain todays date & then display the corresponding 'Serial Numbers' in the first column of Sheet2.
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Search Tabs And Return Results
I would like to summarize all "yes" respose contained in 15 tabs. See the attached. I would like results to be returned to the "summary tab" when user answer "yes" in the signficant column in the "process activity 1 through 15" tabs. If the answer is yes, I would like to pull the process name, aspect and impact detail.
View Replies!
View Related
Search Criteria Bring Values Back To A Results Column
i have the following macro which finds instances of a search criteria and brings them back to a results column. what i need is instead of having the word GD: appear before each result i need it once at the begining of the results LastRow = Sheets("design owb").Cells(Rows.Count, 10).End(xlUp).Row Application.ScreenUpdating = False For i = 26 To LastRow Target = Sheets("design owb").Cells(i, 10) With Sheets("design") For J = 2 To 54 For K = 4 To 11 If Target = .Cells(J, K) Then Sheets("design owb").Cells(i, 11) = Sheets("design owb").Cells(i, 11) + "GD: " & .Cells(J, 15) + " | " End If Next K Next J End With Next i Application.ScreenUpdating = True
View Replies!
View Related
Serach A Column And Return Results Using Macro
Im trying to write a marco that will look in colum E and find criteria "a", then offset (2,1) and copy the activecell and the one below it to a1:a2, then return to where it was and offset (0,1) and then copy the active cell and the one below it to a4:a5. after this is accomplished i need it to return to column E and start the process again for "critera b" paste the result to a7:a8 and a10:a11 I know folks usally post examples of the there code for other to take a peek at however I only know bits and pieces of the process and im not sure how to tie it all together...I was hoping someone could help me get a good start....thanks
View Replies!
View Related
Search A Column Of Dates & Return Data From Another Column
I am trying to get a formula that will search one column range “B” and pull data from another, “D”. Dates are down column “B” and some of those dates are repeated several times. In column “D” there is only one piece of data (a number) entered for each day. Eg, if 08/06/2009 has been entered 3 times in column “A”, there will only be data entered in 1 of the cells of column “D” and blank cells in the other 2. Column B -- Column D 07/06/09 -- 54000 08/06/09 08/06/09 -- 62000 08/06/09 09/06/09 -- 61000 I couldn’t get the LOOKUP function to work properly, as there are duplicate dates in column “B” and I often got a result of 0 returned. As I’ve only got 1 piece of data added in column “D” per day and any duplicate days would just have blank cells in “D”, I can actually get a SUMIF function to work, SUMIF(B3:B60,DATE(2009,6,8),D3:D60). Although it does work, it doesn’t feel right using it and I would prefer a formula that would return just the one cell, instead of the sum of a range of cells.
View Replies!
View Related
Search Column And Return Values
ok I have multiple columns where Col-A can have any number between 1 and 5. Col-B has a 3 digit number in it. i want to search all of column A and determine if there is a 1 in it, if so i want it to print the value of col b into a specified area. here is an example of my form. COLA | COLB | -------------- 1 | 324 | -------------- 2 | 325 | -------------- 1 | 327 | --------------- this is basics, i will be using this to search col-a, determine what number is in the column, then print the number found in col b, on another page in a specific place, on the other page i have squares labeled 1-50. in a grid pattern, 10 squares per row. im trying to get all the entries in col-a, that are a 1, to put whatever value is in col-b in the first box of the grid, whatever is found in col-a with a 2, the value found n col-b of that row, into the grid box labeled 2 etc......
View Replies!
View Related
Search For Text Return Value In Next Column
I'm trying to create a spreadsheet using several others in several different formats. What i need to do is search for a text string eg "EVP" in one column and return the numerical value of the cell in the column next to it - then sum all the values and create a table in the new sheet eg. EVP sheet1!(value)+sheet2!(value)...etc...
View Replies!
View Related
Vlookup: Search For Value In SECOND Column Of Table Array And Return Value From FIRST
I'm looking for a formula to search for a value in the SECOND (instead of first) column of a table array and return a value in the same row from FIRST (instead of the same or another) column in the table array. Formula would be searching for the unique production order number in the column B and return production line id from the column A. A1 production line_id B1 poduction_order_number A2 L1 A3 L2 A4 L1 B2 505212 B3 504234 B4 505663 I was trying vlookup(504234;B2:A4;2;0) to make formula go search from right columns to the left but then excel is switching the search table to A2:B4 and gives #N/D! One remark-there is no possibility to switch these 2 columns to simplify. I have to leave them as they are.
View Replies!
View Related
Search Partial String, Return Value In Next Column, Vba
I would like to search cells in column D for the partial string, "PIPE," (A full string may look like this: 'PIPE, 24"ODx0.375"WT API-5LX-65,ERW OR SMLS'). Then, if it's there, return the value "LF" in the corresponding cell in column C. If that string isn't found, then I'd like it to return "EA". I know this seems pretty easy, but there's a small problem. The word "BENT PIPE," could be in Column D, in which case, I would want it to return "EA" instead of "LF".
View Replies!
View Related
Populate Userform With Search Results
I am trying to populate a UserForm with data from a spreadsheet using a search function instead of just providing a Next and Previous search function (which works). The following code is able to search for and select the correct row on which the data resides. Private Sub cmdBlankFind_Click() Dim FindMe As Variant, FindCell As Range, FindCell2 As Variant, Data As Variant With Range("BLANK") FindMe = InputBox(Prompt:="Please enter search criteria:") Set FindCell = .Cells.Find(What:=FindMe, After:=ActiveCell, LookIn:=xlFormulas, LookAt _ :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _ False, SearchFormat:=False) FindCell.EntireRow.Select Data = FindCell.Value tbxBlankAccount.Value = Data(1, 1) End With End Sub
View Replies!
View Related
Displaying Search Results (filtering?)
I have two worksheets in worksheet 1 I have a bunch of data and I want to be able to filter out to only include relevant results. Eg. If I search for 'Dog' I want search column A in another sheet and find all full and partial matches then display the entire row of each of these matches.
View Replies!
View Related
Copy And Paste ALL Search Results
I have to extract all the entries that have certain words. The worksheet has 600 rows, setup like Column A=unique document number (never repeats) Column B=Document Titles (some repeats, though the documents that are the same are not titled the same, though they have certain keywords in like documents) Column C=Document Types I want to search Column B for all titles containing the word/text string WOR, and then copy the row of A, B, and C when WOR appears in Column B, and put it into another worksheet. Now obviously, I can do a "Find All" for WOR on Column B, but I can't cut and paste the results into another worksheet. I prefer a simple formula, cause my VB and Macro skills are pretty non exsistant, though I will learn if that is what it takes.
View Replies!
View Related
Textbox Search And Display Results
I have a spreadsheet with 2 columns, 'A' is the property number and street name, and 'B' is the year the work is going to be done on the property. I have a form with a textbox and command buttons, now what I want to do is allow the users to enter property number and street in textbox1 and click commandbutton1 to search. If it finds a match I want a small message to come up and say either the year the work will be done (column B) or 'no match found'.
View Replies!
View Related
Search Table For Conditional Results
I have a table which details an applicable fee given a level of performance. However the levels of performance can be any value and the fee level table which i need to look up gives conditional ranges such as if (out performance is) >4.5% and <5.00% then applicable fee will be 0.7%. However my table is large enough that using a nested IF formula seems unfeasable. I've attached a sample of what i mean which explains it better.
View Replies!
View Related
Search Through Database And Display Results In Userform
I have a database of 13 columns and ever increasing rows. I want the following to be there on my userform. 1 combobox: showing the list of categories from which to search.(The categories are the column headings in columns A1 to A13.The user will have to select one category. 1 textbox:Here the user will enter the search term. 1 Command Button: When the command button is clicked/entered, the code shall be such that it will search in the column corresponding to the category mentioned in the combobox and display the results( The entire 1 row x 13 cloumns containing the search term) in a Listbox. If the search term does not matches then a message box should appear with the message "No entries found" [b] 1 Listbox:to display the search result as mentioned above.
View Replies!
View Related
Search Cell That Automatically Filters Results
I am trying to find a way in which a used can enter text into a cell (effectively the search cell) and then that text is compared to text in 3 or so columns, if the text matchs any part of the cells in the those columns then the spreadsheet should filter out the rows that dont have a match and only leave rows that have a match. Its like having a spreadsheet with a list of part an user can put in 55 or bolt in the cell at the top and the list would only then show all the rows that have 55 or bolt or whatever text in the table below?
View Replies!
View Related
Search Database And Display Results W/ Pictures
I have very little experience with programming, as a matter of fact the code in the sample file is the extent of my knowledge. I want to use Excel because not everyone in the plant has access to Access, but everyone has Excel. The idea is to allow searching for parts based on 2 different part numbers, category, drawer, manufacturer, or description (any or all). My first problem is how to make excel search using a userform and find multiple results, not just stopping after it finds the first match. For instance if you only searched for a category it should find all results that match that category. (I'll try to anticipate a question here: the part numbers should be unique but may not be, so using the part number as a key will not work.) The second thing is I would like to know how to populate these results in a listbox and and have the selected part show the matching picture. (This maybe more clear after seeing the spreadsheet). And finally, is there any way to make the comboboxes on the search userform populate themselves off of the list of data. I apologize if any of these questions have been answered already but frankly I've been searching google for the past week and haven't found anything, (This may attest to my search skills as well, ha ha ha), and I really just want this to be finished.
View Replies!
View Related
Search In A Datafile And Copy The Results Into Another Worksheet
I use the Macro below to search in a datafile and copy the results into another worksheet. Only problem, when the macro finds a result he should copy and start over again, starting from the row below, but somehow he start 2 rows lower, so I'm missing results. (when he should copy row 2,3,4,5,6 - the result is only 2,4,6) I tried changing WerkRij = WerkRij + 1 into Werkrij = WerkRij StartRij = Rij + 1 into StartRij = StartRij but then he keep searching and copying the same cells
View Replies!
View Related
Search Sheets For Data Match, Paste Results
I have a worksheet named "List" with static values in columns A & B. I want to search all the other worksheets in the same workbook for the one that matches the value I entered in column B on the "List" sheet. The cell on the other worksheets with the possible match is B5. When it finds a match, I want it to take the data from cell B3 on that worksheet and paste it in Column C of the "List" sheet on the corresponding row (all rows in the "List" sheet have a different value in Column B). In other words, when "List"b7 = worksheetb5 , then worksheetb3 is pasted to Listc7.
View Replies!
View Related
Date Search Macro Runs, But Returns No Results
I'm trying to make a macro to keep track of our rental properties. This macro, in another variant, worked as planned, searching for data in a column, copying the row to a new sheet, and clearing the contents of that row. So I've tried to make it search for a date in a new workbook and do the same. It runs, and tells me it has returned zero significant results (did not find data to move and delete). My column I is formatted mm/dd/yy . And the rest of the workbook is protected. Here's what I have: Sub CopyReturns() 'Macro written 10/2/08 by Jeff ActiveSheet.Unprotect Dim DestSheet As Worksheet Set DestSheet = Worksheets("Sheet2") Dim sRow As Long 'row index on source worksheet Dim dRow As Long 'row index on destination worksheet Dim sCount As Long sCount = 0............
View Replies!
View Related
Trying To Use VBA To Concatenate And Display Search Results On A Userform
I'm using a userform to report on set of worksheets. Two of the functions are: - reporting on the number of contacts with a client - displaying the details of all contacts with selected client in one textbox. I can't work out how to concatenate the text of all the contacts relating to one client in a text box (txtContactHist) on the userform. Using the countIf function I'm trapping zero matches. The worksheet containing the contacts has the following data columns: Col A - Customer ID Col B - Detail of contact Col C- Date of Contact Columns B and C contain the data I want to capture Column A (the customer ID) is the column that is searched for a match ( via the userform text box (txtLic.Value)) To work out the total number of contacts, I use this bit of ...
View Replies!
View Related
Search Workbook & Format Found Results
I was looking at this VBA code the other day and i was wandering what i meant. I thought if somone could expliane line by line, Sub CommandButton1_Click() Dim ThisAddress$, Found, FirstAddress Dim Lost$, N&, NextSheet& Dim CurrentArea As Range, SelectedRegion As Range Dim Reply As VbMsgBoxResult Dim FirstSheet As Worksheet Dim Ws As Worksheet Dim Wks As Worksheet Dim Sht As Worksheet
View Replies!
View Related
Check A Value And Return Results
I have a table that has 6 columns and 5 rows. I need to check a name (division) against the column heading, then and return a classification from the first column based on the score. Below is an example of what I am using (I'm not sure how to post a screen shot): DIV1 DIV2DIV3DIV4DIV5 A91.7689.4198.82100.82102.35 B111.43108.57120.00122.00124.29 C141.82138.18152.73154.73158.18 D195.00190.00210.00212.00217.50 E195.10190.10210.10212.10217.60 DivisionDIV3 Total Score 155.6 ClassificationC
View Replies!
View Related
Formula Return The Same Results
The formula in Col G uses the value in col's B:E. I would like a formula in Col G that will use the 4-digit value in Col F ( same values as Col B:E) and return the same results. ******** ******************** ************************************************************************>Microsoft Excel - PLAY 4 EVE MOSTLY.xlsx___Running: 12.0 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutF1G1F2G2F3G3F4G4F5G5F6G6=ABCDEFG111/10/0966666666Q211/09/0977667766DD311/10/0977767776T411/11/0972467246S511/12/0977667766DD611/13/0978667866DSheet1 [HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name boxPLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
View Replies!
View Related
Return Lookup Results Of All Occurences
I am using vlookup to return data from a range that could have the same name in column A. There are 8 columns Column 1 is Name Column 2 is Sun Column 3 is Mon and so on. The problem I have is that a name can appear in two places in column1 with relevant information in different columns: Fred appears twice, on Wed he is on a course the rest of the week he is on leave. I need a C to be returned for Wed & A/l for the rest of the week.
View Replies!
View Related
Return Multiple Results Based On Criteria
Please see the attached sheets. Here's the issue: On sheet "master" I have a list of goals in column A. Each has been assigned to at least one person. Each person will have their own sheet that will capture the goals assigned to them. As an example, see Al's sheet. I am trying to get Excel to look for all of the goals assigned to AL on the Master sheet and list them nicely onto AL's sheet without out blank rows. (and for each, respectively on their own sheet). I could do this with Pivot Tables if the data were displayed differently, but I have been told that I have to display the goal assignments as shown. I could use "x"s instead of their names to mark the assignment and I could combine the "goal-achieved expectations" and "goal #s" columns if it helps. I am not supposed to use filters either. Note: Of course, a goal or an assignment could change on the master sheet, but the assignment is more likely to change. how this done for AL, I can go ahead and create the other sheets.
View Replies!
View Related
Can Index Or Match Return Multiple Results
I've spent the last week trying to do the following, with little to no success....and I'm running out of hair to pull out!! I have a worksheet (let's call it DATA) with the following column headers: * Site Name * Year Initiated * Status plus a whole bunch of other columns of information. On a separate worksheet (let's call it RESULTS) I'm trying to create a summary of all the Site Names where the Year Initiated = "2004" and the Status = "Active". There will be multiple occurences where this is true. I then want to create further results where the year = 2005, 2006, etc., etc. I've been trying to use the INDEX function with variations of MATCH, SMALL, ROW, etc., etc., but so far, no luck. Advanced Filtering is not an option as I need to do further manipulating of the results on the RESULTS worksheet.
View Replies!
View Related
Return Text Results Based On 2 Criterion
I am attempting to create a formula that will, return text results based on 2 criterion. This is what my sheet looks like Name Job Full Time / Partime Bob Admin Full Time Barry Accounts Part Time Chris Claims Full Time Emma Claims Full Time The formula I have for this is {=INDEX(A1:A4,MATCH(1,(((B1:B4)="Claims")*((C1:C4)="Full Time")),0))} Which is fine and returns the name Chris, however as you can see from above, Emma also meets the criteria given however, I cannot get Emma to appear also. Is it possible to display more than one entry in a cell/s based on this formula, or am I missing something. I would use a pivot table to do this, however I need the sheet to be completely automated.
View Replies!
View Related
Auto Filter Very Slow To Return Results
i have a work book of 12 sheets, the two main sheets 1+2 have 5000+ rows. by 30 columns. each row column b is a site number in ascending order(up to 4 for each site) so auto filter select = to site 5 about 10 seconds later i get the result of 3 sites try site 846 30 odd seconds later up pops the result. so i copied the sheet to a new work book and tried and it's nigh on instantaneous. next step copied sheet paste special values into new sheet in same original workbook and tried filter on that still slow as ever, thing is this book around 8meg and i cant for the life of me work out why ive cleared excessive formats and reset last cell on each sheet. there is a vlookup from sheet 1 to 2 for each site to return serial numbers. i have tried it in vba by turning autocal off/on but still no difference.
View Replies!
View Related
Return Results Based On Referenced Cell
I am looking at developing a table that has three possible options for different categories, being Yes, No and N/A. A yes score a certain percentage depending on what column it is, and the use of N/A changes the percentage of other scores. (i.e. A yes in column 5.1 = a score of 5, a yes in 5.2 = 5, a yes in 5.3 = 10 and a yes in 5.4 = 15. However if 5.4 is N/A then this amount is diveded amongst the remaining 3, i.e. 5.1 = 10, etc.)
View Replies!
View Related
Vlookup Data And Return Results On Multiple Entries
So i have a spreadsheet that has a list of members and how many events they have attended. That is fine because i achieved this by doing a countif function on their account number. The spreadsheet has to sheets Events Attended TOTAl and List. In the list it has their name account number and what event they attended and what date. What i need is to have a function that will lookup their account number and return what event they attended but they might have been to 4 different events. I have a total of 5 columns dedicated to Event attended so we can tell it to lookup first event and return result then have an if function in the next column to lookup event and if its returned in previous column move onto the next event attended.
View Replies!
View Related
Formula To Return Successive Multi Condition Look-up Results
Currently for the first line on the sheet I'm working with, I have the following: =INDEX(SALESMEN!$D$2:$D$500,MATCH(TRUE,SALESMEN!$H$2:$H$500<>"X",0)) which is completed with CTRL+SHIFT+ENTER, and it works properly. However, I want to do the same for all lines following, where it will go to the next item matching that value. For instance: on my SALESMEN sheet, I have John Smith, Fred Johnson, and Mary Williams. Fred Johnson is considered inactive, which is represented in the SALESMEN sheet as an "X" in column H. Therefore, I want line 1 to show John Smith, and line 2 to show Mary Williams.
View Replies!
View Related
Conditional Formatting To Return The Following Results If The Criteria Is Met
I have a conditional format that does not seem to be working for me. Cell B2 has a drop down optionSelect, No, Yes); Cell B3 is supposed to be conditionally formatted to return the following results if the criteria is met: If B2 is equal to No or Yes then colour should become Yellow If B3 is >0 then colour should become Blue The problem is when B3 is greater than 0 it does not change the cell colour to Blue. B3 Conditional Format #1 is =AND(ISTEXT(B2),B2<>"Select") turn background to yellow B3 Conditional Format #2 is =AND(ISNUMBER(B3),B3<>0) turn background to blue See attached for spreadsheet with conditional formats
View Replies!
View Related
Lookup All Occurrences & Return Results To 1 Cell
My task is that I have several documents exported in excel. The requirements in them were mapped to another document. The IDs were populated in a certain column but are now no longer needed. I have to convert those old Ids to the current ones. In my example I have populated Sheet one with the lookup table. In column A are the old IDs. In Column B are the new ones they map to. The old ones can map to several which is why there are more than one ID in some of the cells. In column D of Sheet 2 I have populated it with the old Ids. In Column A I'd like to have the lookup return the appropriate maps to the new Ids. For example for the first map in cell A2 it should return: abc_18 abc_43 abc_6 abc_4 all in one cell. Vlookup can return the first hit (abc_18 and abc_43 for cell D2), but ignores the other two IDs in cell D2. I was able to work around this combining the find, mid, and vlookup to return all values. The problem with that is that the formula gets monstrously big after just having it return 4. In the actual files it can be up to 30 IDs which would make that formula literally pages long since. I have pretty much no experience with macros, but it seems like the only solution since I have to send this off to various people so they can use it.
View Replies!
View Related
Search And Return A Value
In the attached file, I am trying to lookup what vendor is assigned to a part, and enter the vendor number in column J, K or L, depending on the number that is assigned. For example, the top part number, RAD001, has a 2 in column N, indicating vendor # 015354 is the Alternate vendor # 1. It has a 1 in column V, indicating 034180 is the Primary Vendor, and it has a 3 in column Z, to indicate that 015229 is the Alternate Vendor # 2. What formula would I need to put in cell J2 so that if a 1 is found in row 2 it will return the value 1 position left of where the 1 is found? I will then put a similar formula in columns K and L to return the vendor number if a 2 or a 3 is found. The end result will be that for each part number you will be able to see what vendor is primary, alternat 1 and alternate 2. I want to make this a formula because the actual sheet will be thousands of part numbers long, and I will need it to update the vendor information if the primary vendor is changed.
View Replies!
View Related
Search Value And Return An Associated Category Name
I'm attaching a spreadsheet in order for you to understand my question, and I will explain it based on that, ok? I apologize in advance for english mistakes, since it's not my 1st language. I want to search the salary value in column B and, in Column C, I need the job title to be posted based on what is written in Column J. The table h2:i8 contains the maximum salary a person on that position can earn. So when you look the salary on column B, it should seach in column H and compare to the maximum value, and return the description on Column I that corresponds to that salary range. So if somebody earns 6500, it should be qualified as a supervisor, because its salary maximum is 7100. I have searched the forum here and found similar problems, with suggestions to use vlooup and Index. But I just can not figure it out.
View Replies!
View Related
Search And Return Address For All Matches
I'm looking for a Formula in order to retrieve all addresses of all matches equal to the search criteria located in cell: E2 The results are hand-typed in col. G This is a case of a TWO-DIMENSIONAL "Arbitrary Lookup" Arbitrary. The range A1:C10 was named: TBL and the formula should refer to TBL as it can be dynamic in size. PS: can anybody tell me why I don't get any E-Mails when an answer is posted?
View Replies!
View Related
Search Engine Will Return All The Information
i want is to create a search engine in excel that allows users to input the clients name and the search will return all the info on the client such as the issue and their policy number. Is this even possible? Using Access is not an option. I know I can use Access but most of my users dont know how to use Access and I want to make things as simple as possible. Thanks so much in advance who ever succeeds at provding an answer u're a genius cuz I have no clue where to start lol.
View Replies!
View Related
Search In TextBox, Return In Listbox
I'm using a Textbox macro to search my database for a specific date, and return the company name of all entrys for that date, into a ListBox. Now this is the only way I'm prepared to look at doing, and I have managed to do it...... partially - as stupid as it sounds, I cant get multiple results to list in the ListBox itself, and for the life in me I cant find out how to do it. Also, once the options have been brought back into the ListBox, I then need code which will then populate further locked TextBox's which the rest of the company info, when selected from the ListBox. I know its asking alot (or maybe not) but I believe, (unless ive done it a really awkward way, I'm not too far away, I just dont know the code to enter, to be able to do it. Private Sub CommandButton1_Click() Dim Nullstring Application.ScreenUpdating = False If TextBox1.Value = "" Or Nullstring Then MsgBox "Please enter a date to search for" GoTo error1: End If.....................................
View Replies!
View Related
Search A Table, Return An Array
0000AAAAABBBBBCCCCCDDDDD 1111SugarRaisinDirt 2222MilkWaterWaterFlour 3333FlourSugarDirt 4444EggsWaterFlourSugar 5555WaterMilkDirt I looked for a way to represent my data in a cleaner way than this but couldn't find any tools....a point in the right direction would be helpful. I guess the old plug-in that converted Excel->HTML isn't available? Column A is a finished product and B-D are the ingredients to make it however values in Column A are also ingredients (sometimes multiple times). I want a formula that searches for values in Column A within the table B1:D5 and returns an array, if possible, of the finished products where Column A was used. For example, searching for Sugar would return "Flour, Water". Searching for Water would return "Milk, Eggs" (I'd rather not have Milk listed twice but beggars can't be choosers).
View Replies!
View Related
Return Cell Containing Search Criteria
If I have a 'key' value in a cell in one sheet, i want to use that value to find the cell in another sheet containing the 'key' and return the row number of the cell, if more than one value then I would like to be able to loop through all the rows containing that 'key' value returning the row number of each hit, kind of a programmatic version of vlookup?
View Replies!
View Related
|
TRACKER
