Formula: If Value Return Is = To Value Of Cell Above Then Find Return Next Value
Is there a way with the following formula to tell it that if value return is = to value of cell above then find return next value?
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Lookup Formula: Find And Return Value
I have a column with 11 different numbering schemes that go from 736466.01 through 736466.11 In the group from 736466.01 through 736466.07 I need to have the adjacent column look to those cells and if it finds 736466.01-.07 return "CM" if it is 736466.08-.11 I need it to return "TC". I created the formula below but it doesn't like something I have done unless I change the format of the 736466.xx to text. Anything other than 736466.01-.11 should return a "null" or "void" Can you help me improve this formula, or show me a better way of creating it? =LOOKUP(E2,{"736466.01","736466.02","736466.03","736466.04","736466.05","736466.06","736466.07","736 466.08","736466.09","736466.10","736466.11"},{"CM","CM","CM","CM","CM","CM","CM","TC","TC","TC","TC" })
View Replies!
View Related
Index Formula (find The Relevant Data And Return In To Sheet2)
I have a spreadsheet with multiple columns. (Sheet1) The heading row is my customer name. (Sheet1) My column are the dates. On another spreadsheet, I would like to find the customer in Sheet2 in Sheet1, then do an index to find the relevant data I need, returned in Sheet2. Sheet2: find customer "ABC" in Sheet1, if found, then find the date that also matches Sheet1 and Sheet2, and return data "apple" . sheet1 DATE ABC DEF 2007-04-01 £55.60 £61.13 2007-04-02 £56.33 £60.27 2007-04-03 £52.14 £62.58 2007-04-04 £51.69 £61.28 sheet2 CUSTOMER DATE RATE DEF 2007-04-04 This should be £61.28 ABC 2007-04-02 This should be £56.33
View Replies!
View Related
Formula: Find The “best” Contact Information And Return The Result To The Merge Sheet
I have a formula that needs some tweaking. This formula is to reference the ACCT and find the “best” contact information and return the result to the Merge sheet. If the ACCT does not have a Parent then you reference the ACCT to the abc_Phonelist sheet. If the ACCT does have a Parent then use the Parent ACCT since it has a more desirable account number to reference against the abc_Phonelist. If the ACCT or the Parent ACCT uses Processors then the ACCT from the Processors sheet has the best reliable account number to reference against the abc_Phonelist. In sum, there are three different possible “number tiers” that can be used. The first, the ACCT phone number. This means that the ACCT has neither a Parent nor a Processor. The second, the parent ACCT phone number. This means that the ACCT has a Parent, but neither the Parent ACCT nor the ACCT has a Processor.The third, the Processor phone number. This means that either the ACCT or the Parent ACCT has a Processor phone number.....
View Replies!
View Related
Find Cell Based On Return Of MAX Value
This time I'm trying to use the max value and row value at the same time, but it won't let me. Here's what I'm trying to do... A B C D 1 a b c d 2 7 9 4 2 3 e f g h 4 8 2 7 8 5 i j k l 6 4 3 3 9 I want Cell A7 to return the letter before the highest value in column A... A7=e B7=b C7=g D7=l I tried to do something using two cells, but even then I couldn't figure it out. I thought a ROW(MAX(A1:A6)) would give me the row and I could go from there, but that didn't work.
View Replies!
View Related
Find Value In 1 Of X Worksheets & Return Corresponding Cell
I have a problem with VLOOKUP. The Value im trying to look up a value which is one of 5 sheets Called Con1 to Con 5. These Sheet names are in an Array called "ArrCons" the look up value range is also a variable and looping through column "C". The table Array is on Sheet "Con" Range "A:E", return column is 2 and the logical value is "false". ActiveCell.Offset(i-1,2)=Application.VLOOKUP _(ArrCons(y)!C & i -1, Sheets("Con").Range("A:D"),2,False)
View Replies!
View Related
.range.find Need To Return Cell Address
when I use the range.find function to find a certain value in a column.. i want to return the address of the cell.. and save it in a range variable. how would I do that? so this is what i have now.. but Rng does not return as a range.. it returns 69... when i use ctrl + G and type ?rng set rng = .range(A:A).find(what:=69, After:=.Cells(1, 1), Searchorder:=xlByRows, searchdirection:=xlPrevious) ok so say it picks up..... cell A69... how do i get it to save range A69
View Replies!
View Related
Find Cell Value In Column & Return Corresponding Value
I am drawing a complete blank of this one. I know it can be done but I can't seem to remember how I did this in the past. I have a sheet that has cells A1 at MB, A2 as ML A3 as MD Then in cells B1 I have MB,TL then in B2 I have ML and then B3 is Blank this time. Then in cells C1 I have Jim, C2 has Jack, and C3 has Fred. What I want to do is have a formula that is in cell D1 that looks at the value in A1 and finds that value in Column B and if it is found return the value in the same row in Column C. In the example it would show Jim since MB is found in cell B1.
View Replies!
View Related
Find/Return Nth Letter In Cell
I'm trying to write a macro where I match specific letters from one cell, with a column in another sheet so I can copy/paste adjacent cells. As an example I have a list of part numbers in column A of my Document1: ex. C12932-1 C13226-2 I want to be able to find the corresponding part number in column A in Document2: ex. C-12932 C-13226 However the proplem is clearly that the part numbers are written differently. So I need to just search for "12932" or "13226"
View Replies!
View Related
Find Value & Return Contents Of Offset Cell
On Sheet2 I have a table where I want M2 to do the following: 1.) Look at cell A2 where the name "John" is and B2 where the name "smith" is. 2.) Look at sheet1 and look in B2 and C2 for "John" and "smith" 3.) Once it matches the name, place the contents of sheet1, cell I2 into sheet2, cell M2. So in short, match the name on sheet2 to the name on sheet1 and return the number in I2 to M2 on sheet2. Maybe combining the persons name in to one column would make it easier?
View Replies!
View Related
Find Value & Return Offset Cell Content
I would like to be able to find all cells in row 2 that are "greater than 0". Then I would like to return the coresponding job number in row 4. I need to create a list of each job with the number of hous spent on that job next to it. I may have 30 different jobs but only 5 jobs that have hours for the specific week. How I attemted to solve this is to create a table that listed all the hours from the largest number in row 2 to the smallest. Then I found the job number corresponding to that number of hours. The problem with this meathod is that if two jobs have the same amount of hours then the first job number is returned for both values that are the same. See attached example.
View Replies!
View Related
Find Cell Value In Column & Return Text In Adjacent Cell
I have a drop down list in a merged cell B12-F12 and B13-F13 and B14-F14 . . . B30-F30. I need the adjacent merged cell to populate a reason (text) based on the text answer in the drop down list or the entered text in the first merged cell. For example in the cell B12-F12 the user picks from the list or types in "Amiodarone." I want the adjacent merged cell G12-J12to automatically fill with "Heart Rhythm." I also want to be able to set up multiple if - them statements like if Amiodarone is entered then fill adjacent cell with Heart Rhythm and if Toprol XL then fill adjacent cell with Heart / Blood pressure and if simvastatin then fill adjacent cell with Cholesterol, etc. I have about 30 different options for cell 1 that I want to have auto fill in cell 2 based on the contents of cell 1. I've attached my file. I want the user to be able to choose from the list or type the drug name in.
View Replies!
View Related
Find Cell Value In Another Workbook & Return Adjacent Cell
I am trying to complete these steps: Take a value from AK59 from the "EQF" tab in a file called "QuoteMaster.xls" Use that value to find match in column "A" in a Seperate workbook "ITMSTR.xls" on the "Sheet1" tab Offset to the right 1 cell of the found value, take back to the "QuoteMaster.xls" and put in cell "AN59" My code comes up with no errors, it opens the file and closes is as shown, but it doesn't copy the value over for whatever reason...
View Replies!
View Related
Find Date In Column & Return Adjacent Cell Value
I have a spreadsheet with a column A of dates April 08, May 08, June 08 etc. Adjacent to each of these dates is a value in column B. I want to select the appropriate value relevent to the current date and use it elsewhere. Therefore if it happens to be Oct 08 when I open the spreadsheet I want the value in column B, adjacent to Oct 08 to be represented.
View Replies!
View Related
If Then Formula: Return The Value Of The Cell
Here is the formula I used to return the value of the cell. =+((L2-O2)/250)-0.5 It return negative numbers so I used the If statement below to return 0 for any negative number and then I want it to return the value of the cell if the number is not negative. How do I finish the balance of the if statement to make that happen? =IF(P2<1,"0",)
View Replies!
View Related
Find Data In Column Range & Return Cell Same Row But X Columns To Right
i have is 3 sheets in the same excel document. Sheet 1 is the mater sheet, which is a compilation of sheets 2 and 3, however the sheet layouts are different. The sheets consist of a list of names and details. Sheet 1 has all the names in the list, however sheet 2 and 3 only have partial lists that are in a different order from the original list. The details listed next to the names in sheets 2 and 3 are different and hence a straight forward row copy and paste will not work. What i need is to write a vba script that can take the name from the master list, search sheets 2 and 3 for the name and lookup the variables placed in next to the name, then update the master sheet accordingly, then continue to the next name on the master sheet and do the update again, and so on until all is updated. I have already thought about using lookup functions in excel however there is 1000 names on the list and around 60 details so it would be messy.
View Replies!
View Related
Return Selected Cell Name Formula
Is there a formula that will return in A1 the selected cell name in range B1:B10 example : If I click in B2 I will read in A1 the word "B2" Easy to do with a message box but a formula? I do not want the user to have to accept macros when he or she opens the file Edit: If easier I could type in the cells their name and have the formula in A1 return the selected cell's "VALUE" example In B1 I would type B1 etc...
View Replies!
View Related
Return The Date In The Cell Containing The Formula
the last date input into a range covering multiple columns and return the date in the cell containing the formula): {=index(a9:n9,1,max(if(cell("format",a9:n9)="D4",column(a9:n9)))-column(a9)+1)} My column headings use this pattern: Column A: Date Column B: Amount Column C: Date Column D: Amount Column E: Date Column F: Amount and so on. When I use the above formula, I end up with data from the last amount column instead of the last date column.
View Replies!
View Related
Return The Relative Formula Of Another Cell
I currently have a list of totals that i want to easily be able to change the cells that make up this total. I have been trying to set up one cell that contains the formula and then the remaining totals below are linked to this cell. Thus I change the formula in the top cell all the other totals also change.
View Replies!
View Related
Formula To Return Last But One Cell In Row
I currently use the following formula to find the last used cell in a row: =LOOKUP(2,1/($6:$6<>""),$6:$6) which works fine but I have been trying to amend it so that it returns the last but one cell in a row. Have tried using it with Offset but without success. Have found other solutions to finding to the last cell in a row albeit that a number of them do not seem to work with my project and likewise none of them seemed to allow customisation of any sort.
View Replies!
View Related
To Return A Blank Cell In A Formula
i have IF sentence that returns either a number or a blank cell (tried using "") in a colum. This data is entered in a chart. My problem is that that excel dont recognise the "" as a blank cell in my chart. Is there a way to do this? i could maybe use VBA to make my own function that clear.contents if the cell value is smaler than say 1?
View Replies!
View Related
Find Cell In Array, Return Value Of Cell Next To It
I have a table with multiple columns in which I want to find a value, then return the value that shows up to the right of it. For instance: I want to look for a unique value that exists in a cell somewhere in columns B-F, then I want to return the value of the cell in the next column. So if I have value XYZ, and it's found in row 12 of Column B, I want to return the value in row 12 of column C. Any way to do this with an index and match or some other formula?
View Replies!
View Related
Find First Blank Cell In Column & Return Adjacent Date Less Than Or Equal To Today
how to make the data look like a table with three columns. Other than the date, it is space delimited. I have a tracking spreadsheet where Column A is populated with dates for the year. Column C contains daily values. I don't always start entering daily values on the first day of the year, e.g., this year the first value in Column C corresponds to March 9. All values in Column C are contiguous - there are no blank cells until the value in Column A is greater than today's date code. I would like to use a formula (rather than VBA) to look down Column C and find the first non-blank entry where the value in Column A is less than or equal to today(). In this case, the formula should return the value for March 9, 2008. CREATE TABLES LIKE BELOW?Column A Column B Column C March 1, 2008Saturday March 2, 2008Sunday March 3, 2008Monday March 4, 2008Tuesday March 5, 2008Wednesday ...................
View Replies!
View Related
Return Cell Reference Of Large Formula
I am creating a summary financial sheet in Excel 2003, Win XP. It needs to show the top 10 sales variances from a large data list, along with the associated department. I can bring in the top 10 largest variances using Large(array,k), but because variances are either positive or negative, I'm not really showing the true top 10. To fix this I can use absolute values via Large(abs(array),k) but then I don't know how to convert the value back to its original sign (positive or negative). If I could somehow get the cell reference that the Large(abs(array),k) formula points to, I could do something like this: =Large(abs(array),k) * (Large Cell Reference/Large Cell Reference) I'm afraid to use the address function because of duplicate sales variances. I often have several variances of with same value, so I might not truly be pulling the address that the large(abs(array),k) is pointing to.
View Replies!
View Related
Formula To Return Values In A Dynamic Cell
I basically have this worksheet which has Cell D3 Being Dynamic. It puts the lowest cost supplier from columns H:W. If i change the prices in H:W it will bring up the lowest cost supplier in D3. Once D3 is chosen i want it to self populate F3 and G3 based off of what is in D3. This data should be pulled off from what is in the H:W columnns corresponding to the supplier in D3.
View Replies!
View Related
Return True/False If Cell Contains Formula
Is there a formula or VB code like the =TYPE() function that will return whether a cell contains a FORMULA? Here's the issue: I'm writing a macro to update 10,000 sheets. Each sheet has a column that I'm updating with a new formula. Some of these formulas have been previously overwritten with a random number that would delete the formula from the cell. I have to leave the overwritten values where there is no formula, and replace the values of the formulas where they are still intact. I assume that if I can identify whether there is a formula in the cell or not, I can choose that cell to skip or update.
View Replies!
View Related
Using IF(OR And IF(ISERROR In Same Formula: Return A Blank Cell
I am trying to fix the below formula =IF(OR(ISERROR((F26-E26)/F26),((F26-E26)/F26)=1),"",(F26-E26)/F26). If I get an error from the formula I want it to return a blank cell. If I get 1 as the answer to the formula I'd like it to return a blank cell. This formula only works if the result is 1 but won't return a blank cell if the answer is an error.
View Replies!
View Related
Return A Cell Formula's Parameters
i need to essentially find and replace udf's and the complication is rearranging the parameters in the udf's into a new formula structure. so my question, is there an easy way to extract a parameter (or all parameters) from a function? for example, if you had = SUM(A1,A2,A3:A6) you would return 'A1' as the first parameter, 'A2' as the second and 'A3:A6' as the third. Obviously it gets complicated when you nest functions such as =SUM(IF(A2=1,0,A1),A3) etc and the if() function would be parameter 1.
View Replies!
View Related
Formula: Return Result Based On Other Cell Values
I have a spreadsheet that give me the percentage difference of two cell say a1 and a2 (=a2/a1)[format as % two decimal places]. The result is on say b5 as a %[format as % two decimal places]. Now on B6 I want to do this: if B5 is >3.01% then b6 =" Market Test Required" if B5 is +3% then b6 =110 if B5 is +2% then b6 =106 if B5 is +1% then b6 =103 if B5 is 0% then b6 =100 if B5 is -1% then b6 =96 if B5 is -2% then b6 =93 if B5 is -3% then b6 =90 if B5 is >-3.01% then b6 ="Market Test Required" So on and so on.... I would really appreciate your help on this issue. I have used excel for some time now but not with complex formulas or any vb.
View Replies!
View Related
Return Formula Value/Text Based On Many Cell Conditions
This is to manage which departments (approxiamately 30) within a business need which compulsary training (approximately 11 courses) Spreadsheet currently reads list of new employees and I want to be able to have "YES" or "No" values under the different courses Is there a formula/function that i can use (like the IF Formula) to complete the following information; EG: =IF(OR(A3=H2, A3=H5 etc... ), "YES", "NO" Column H lists all departments Column A lists deaprtments A3 representing the 1st Department needing training
View Replies!
View Related
Formula To Return The Value In A Column Based On Cell Entry In Row
Trying to write a formula that looks for the first number in the same row, then returns the value in that column in a different row. In the example included, cell A-7 should contain the formula. Within row 7, determine the column where the first number is listed (column D in this case), then return the value listed in row 3 of that column ('C' in this case). I've tried Lookup, Index, and Match functions, but can't seem to get the right combination.
View Replies!
View Related
Find & Return One Of Many Values In Cell & Lookup Corresponding Match
Working on an export from an e-commerce application that lists the item purchased, unfortunately not by item #, but rather a lengthy description. I'm trying to construct an item number based on that description which contains several constants. Each item ordered appears in a single row, comprised of ORDERID, QTY, PRODUCT DESCRIPTION I have several tables to pick out PRODUCT TYPE, COLOR, SIZE, etc. I need a formula to search to see which of the unique values appears in each in the cell and return the shortcut of that value. PRODUCT DESCRIPTION example "Sweater - Blue - Large - Wool" TYPE TABLE: Sweater SWTR T-Shirt TSHT Jeans JEANS COLOR TABLE: Blue BL Green GN Purple PL Black BK I would have separate tables for each part of the description. The formula I'm seeking would search the PRODUCT DESCRIPTION cell for the range of values for each 'part'. So it would search to see which of Sweater, T-Shirt, or Jeans was in the cell and then return the one that was - SWTR in this example. I would modify this formula for each 'part', in its own cell, and then use an =cell#&"-"&cell#&etc... to combine these returned values. I know I can write a large if- chain using ISERROR & FIND, though some of these lists will get lengthy.
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() If(...........) End Function
View Replies!
View Related
Return Top N List & Return Corresponding Data For N
I am trying to find the largest value, second largest, and third largest value for a column of numbers then return a content value for the adjacent column that contains the name for which each. The problem I am running into is when the second highest has the same value as the highest and also when the third value is zero (n=meaning there are only non-zero numbers for the column). I am using these formulas currently whic work when the numbers are not the same and I have atleast 3 non-zero numbers but I need to modify in order to account for the problem stated above...
View Replies!
View Related
Return Value From Find Method
I am having trouble using teh find method. I'm using it to search for a string in a column, then give me the row number, which is fine when the string is found, but when it is not I get an error of "variable not set." I'm pretty certain it is returning void, but how to I capture that? Here's the voucher_row = Worksheets("Table").Columns("D:D").Find(voucher, LookIn:=xlValues, LookAt:=xlWhole).Row "voucher" is a string.
View Replies!
View Related
Find/Return Unique Data
i have 2 different spreadsheets sheet 1 and sheet 2 in sheet 1 i have suppouse following data Name-- Prod. --value --year -- a -- 24 -- 100 -- 2004 -- b -- 26 -- 240 -- 2004 -- a -- 33 -- 120 -- 2004 -- a -- 21 -- 200 -- 2004 -- c -- 26 -- 240 -- 2004 -- b -- 33 -- 120 -- 2004 -- d -- 24 -- 100 -- 2004 in sheet 2 Name -- Prod. -- value -- year -- a -- 24 -- 100 -- 2005 -- d -- 26 -- 240 -- 2005 -- a -- 33 -- 120 -- 2005 -- e -- 26 -- 240 -- 2005 -- a -- 21 -- 200 -- 2005 -- c -- 26 -- 240 -- 2005 -- d -- 24 -- 100 -- 2005 in this situation i want to find out the dropouts of sheet 1. (that persons which are not present the sheet 2) how can i compare these sheets? in this case i want the result as -- Name -- Prod. -- value -- Year -- b -- 26 -- 240 -- 2004 -- b -- 33 -- 120 -- 2004
View Replies!
View Related
Find X In The Corresponding Row And Return The Header Value
I need a formula to put into cell B19 to Find X in the corresponding row and to return the header value ******** ******************** ************************************************************************>Microsoft Excel - Book2___Running: 11.0 : OS = Windows .NET Server (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutA1=ABCDEF1Part NumberDescriptionSubframe BuildCut And ChopHopper BuildCabBuild2026319Assy Air Ram Auto Blanking X 3026321Assy Air Ram Rear Boom L/H X 4026320Assy Air Ram Rear Boom R/H X 5022587Assy Air Ram Side BrushX 6031159Assy Air Ram Side Brush Large DiameterX 7030501Assy Blanking Flap Valve Single Vm Minor 8034783Assy Brake Pedal Lh Vm Minor Fl X9034784Assy Brake Pedal Rh Vm Minor FlX 10036349Assy Brush Control D/S No Hp Opt Mer/Mag X 11024553Assy Brush Core 1300 Large Widesweep X 12024554Assy Brush Core 1300 Small Widesweep X 13023169Assy Brush Core Large 7000 X 14025662Assy Brush Core Large 80/85 X 15032482Assy Brush Core Magnum Poly/Wire Mix X 16 17 18 19034784Subframe Build 20023169Cut And Chop Sheet1 [HtmlMaker 2.41] 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
Find Value In Row, Then Return Heading Above It
I have a 10x10 table. First row contains column titles (plain text, hardcoded). Each line below them has a 1 in *just one* cell. So, each line contains 9 zeros and one 1. In the 11th column I want to check which column has the 1 in it and return the column's title. So, if the 5th row has a 1 in cell E5 I should get, in K5, the value of E1 (the title of the E column that is).
View Replies!
View Related
Find Replace With A Carriage Return Using VB
Selection.Replace What:="GD", Replacement:="BLACK", _ LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:= _ False, ReplaceFormat:=False Selection.Replace What:="WD", Replacement:="WHITE", _ LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:= _ False, ReplaceFormat:=False GD and WD are in the same cell, I would like the end result to go from GD WD to: BLACK WHITE
View Replies!
View Related
Find Date & Return Corresponding Value
Need to convert price on transactions throughout the year to different currencies - using historic currency exchange rates. Entered data in columns A-D: Date1 | Value1 | Date2 | Value2 | Required Formula to generate column E for each row individually (to 2dp using d/m/y format): Value1xValue2whereDate1=Date2 Date1/Value1 will be prices on certain dates while Date2/Value2 will be historic exchange rates for every day of the year.
View Replies!
View Related
Find Two Values In Worksheet To Return One Value
Attempting to find identical values in cells B3 & B4 located in another worksheet titled "Density Chart" and to return the value in cell/column D. The Density Chart values are located in column A & B and the value I want returned, depending on the criteria entered would be found on the same row but in column D. Example... Changeable Value in B3 = A123 (can also be completely alpha value and will be different values each time the formula is used. Changeable Value in B4 = 2.00 (always numeric value) Density Chart information ColumnA ColumnB ColumnC ColumnD A123 2.00 55.555 65.555 A123 2.40 55.555 75.555 A123 2.70 55.555 70.555 B123 2.00 45.000 85.000 C123 D123 E123 etc I have tried =if, I have tried =sum product ... at a loss
View Replies!
View Related
Code To Find In A String And Return
I am trying to search a string for the first instance of "#" and return everything to the left of it and right of the word "where". Example String - Where 11# is greater then 10# I want to just return 11 11 is left of the # and right of "Where"
View Replies!
View Related
Find And Return Part Of A Date
In A1 I have a date '01/01/2008' and in B1 I want it to return the year and month which I have acheived with =year(A1)&month(A1) which returns '20081'. This is great but I want the format to return '200801', not '20081'. Also if A1 is blank I want an empty cell in B1. I tried this with the following but have failed.. =IF(A1,"","")=YEAR(A1)&MONTH(A1)
View Replies!
View Related
Find , (comma) And Return All Characters After It
Excel 2007 - Windows XP I have the below in cells A1 and A2. I need to find the last comma then return all characters after it. I need the same formula for both cells because the value is always changing. HUG,PU-TUB,BW,-,-,64 Need to Return 64 in B1 HUG,PU-RFL,BW,-,-,176 Need to Return 176 in B2
View Replies!
View Related
Find & Return Corresponding Data
Im trying to create a marco that will feed cells in one sheet from data from another sheet. I want to be able to enter a "project number" into the corresponding cell, then all other related areas will populate across. refer file attached. If i enter the project number in D4 (sheet 1), then the "Buyer", "Project name", and "Category" data will pull across from sheet 2.
View Replies!
View Related
|
TRACKER
