finds

Here is a picture of my spreadsheet and what I am trying to figure out how to get it to do what I need it to do: The selected row (row 5) shows some cells that contain either a value of either "R" or "E". I need a If statement that checks a range of: Range(Cells(5, 6), Cells(5, lCol)), but...

Hello, I am new to macros and this may be a simple question, hope you can help. PLEASE!! Thanks! I'm trying to search for any string with a ":" from column M and move it to column D but start at a specific row based on a search i have. For example: This finds kis emr and returns the row...

Hello I am trying to produce something which when ran will give me the value of a cells. The workbook is made up of Sheet 1 and Sheet 2. Sheet 1 will be populate by a dump of data from a different workbook and wont always be the same in size due to different number of periods. What i need is...

Hi All, I am in need of some assistance again. So I am trying to figure out a way to have excel look through a range of rows and stop when it finds a value. This value would be text, but any value would do. The way I set excel which column to look at is by using...

I have a sheet with this formula. It finds an alphabetical list in column GO on a sheet called "'Alphabet CopyPaste". My problem is that my alphabetical list has duplicates in it and from reading online, my formula only finds the first duplicate. I've read about a few workarounds but I can't...

Hi I have a spreadsheet with a chunk of data. Could do with a macro that would look in column I, starting at row 2 and place info into Column A in the corresponding row. Info is as follows: If it finds 1289 in column I, it needs to put XY40 in column A If it finds 1060 in column I, it needs...

I have merged cells in column A - imagine my name merged down from A1 to A3. Then I have data in B1, B2, and B3. On another sheet I have a vlookup that's looking for my name. A regular vlookup finds my name in the merged cells and returns the value from B1. But how do I write a vlookup that...

Hi using this formula if nothing found return 0 I would like to change it if it finds nothing to return blank not 0 =IFERROR(VLOOKUP($H$3:$H$100, Data!$D$2:$AH$100,25,0),"") Thanks

Hi Everyone, I've got an Excel Table that contains different columns of data. Some rows have formulas in it, some of them have data i input manually. Example: (You can find the Formula below the table, because it's a little long) <tbody> Name Serial Quantity Hours Price Formula a12 10 4...

I have 4 formulas that work independently. Two are similar to the other two in what they look for. I'm trying to put them all into one formula. How do I nest them so that if Excel finds #1 , it doesn't look for #2 , and if it finds #3 it doesn't look for #4 ? It would never find #1 and #3...

Hi all, I have an existing spreadsheet, which has had 3 new tabs added to it. In the original tab (TAB-A), I need to perform a vlookup on the data in column A, looking in the 3 new tabs for the data. The thing that makes it a little complex, is that if it finds the data in the 1st new tab...

Evening All. I need help with two formulas that lookup dates and return a value from an adjacent cell. The first of these formulas is as follows. In range A5 to A1500 there will be a range on ascending dates. In column C5 to C1500 there will occasionally be a numerical value. I need a formula...

So i want to Lookup "PL01053" in a table that has multiple records. However there is also a record that is "PL01053A", I don't want it to find that one, I know the Vlookup formula will search until it finds the FIRST record that contains all that data. how do I get it to exclude PL01053A and...

Hi I'm looking to create a formula to look for either "MAY" or "SEP" as a code in the string. if it finds eaither then "1", "0". = IFERROR(SEARCH("MAY",[DISCOUNT CODE]),0) Thanks

Hi, I'm looking for a macro that will look at the value (text) in cell A1 of Sheet1 then go to Sheet2 and search for the same value (it will be unique) in Row 4 of Sheet2 and then when it finds the location in Row 4 select the column which is one column to the right and rows 10:200 of that...

hi all I have the following to delete the last non-empty row [Sheets("sheet1").Cells(Rows.Count, 1).End(xlUp).EntireRow.Delete] I also need to add to the above code once it finds this row to delete the row immediately above it. Can someone please assist.