return values

  1. F

    Merge Fields used in word document

    Hi, I have created a word mail merge template from data in an excel document, and I think I'm nearing the 256 column limit - so need to check what exactly I'm using and what (out of the 256 fields) I'm not currently using... What I'm after is some kind of macro that will allow me to open up...
  2. S

    Advanced return values that don't match and highlight cells

    I'm looking for formulae that will compare Sheet1 and Sheet2, searching Sheet2 for cells that don't match columns C-E for the associated ID and Date (columns A & B) in Sheet1. Further, I'd like to highlight in Sheet1 whatever cells in columns C-E that don't have matches in that can be found in...
  3. R

    Excell VBA Sub to search upto 19 Columns and upto 150,000 Rows

    I have a very weird Ask I have a excel sheet with a huge amount of data. 3 sheets one with 150,000 rows of data and 19 columns and 2 other sheets that are not as large but up to 50,000 rows of data and up to as many columns. I then have an entry Sheet That allows a user to enter data into any of...
  4. A

    Returning multiples rows and columns using Vlookup or any other function

    Hi, I have a data table to which I'm trying to do a vlookup to return all the columns of a matching lookup value, which I was able to do, but only one matching row would appear, while I want all matching rows (and not only the first match). Also, another issue I have is that a vlookup will...
  5. C

    Formula for if L21 equals column AC then return value in AD to K21

    Fun times here. I have a Branch name in Column L21(which is a formula taking a branch name selected from Column C14 (drop down to select other branches) but always start in L21. I need Column L21 to look at Column AC2:AC40 and if a match then take what is in column AD (depending on where it...
  6. P

    How to return the text that is in one column, in another column, ignoring zero values or blanks

    I have a column that has some cells filled with text, and some blank. I want to create a separate column that returns only the cells filled with text, ignoring blanks. I've shown what I mean in a table below. Is anyone able to help with this? <tbody> Column with data Return with formula...
  7. T

    Reducing Formulas for finding Text in a String

    Happy Monday Everyone I can make my way around excel (just), but once I figure out a way to get something working, I usually leave it there. I created a formula to build a Sheet VKUP_PAGE to use as a VLOOKUP table and return one of 3 variants of the following examples in Sheet TESTPAGE...
  8. D

    Lookup last date and return with result

    Good day, I am struggling to put a formula together. I need to get the opening and closing from sheet1 (Below) and put it into sheet2. I need the balance from the last date but not later 2015-03-31. Some accounts the last date is in 2014. I need to do this for +- 23000 accounts. any assistance...
  9. S

    Vlookup Help to find a matching value

    Hi, I have worksheet 1 with a list of companies and worksheet 2 with a list of companies by rank (column A has the rank and column B has the company names). I would like see which companies from worksheet 1 are in the company rankings of worksheet 2, and return the rank number to worksheet 1...
  10. F

    Import log that searches for previous matches

    Firstly Apologies if this has been answered elsewhere on here, but I have had a looka nd cant find quite what I was after. I have a form, that once completed and sent to me, I can import the information from the form to a log that I have, from a button that rus an import macro and does a few...
  11. D

    Returning a value based on multiple criteria

    Good Morning All; I'm sorry if this is covered in another post but frankly I could think of how to describe what I'm trying to accomplish (or that its practicibly possible for that matter). Below is a data set that I'm trying to query. Essentially each investor is separated into their own...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top