return results

  1. J

    Possible Index/IF Function

    I am trying to figure out the formula where I need a cell to auto populate a result based on the input of another cell. For example. Column A (Region) will be the cell that will have the input. Column B (Destination Location) is the cell that I would like to auto populate based on the input...
  2. D

    Search two columns using one criteria return third column

    The results in column "N" are either in column "T" or "U" I need to be able to find the matching number in Column "T" or "U" and return what is in column "V" into column "K". If no results are found it needs to say "check lookup table" Index, Match will only look at one column, not sure what...
  3. T

    Combobox value loop column lookup and return all matching results to a sheet

    I have a little trouble with this one. I have three combo box that I required the value of each box to lookup the data in Sheet 1 Column E, F, G and when a match is found return row number so that all data in Column H, I, j, k, L are placed to Sheet 2 in the next available empty row. However...
  4. V

    Compare two columns in one workbook with two columns in another work book and return values

    I have a problem and in desperate need of help. I am trying to create an analysis tool to compare the information in two workbooks and return data to the source workbook. For example; I have two work books, one current and one history that I want to compare and return the status and status date...
    • Vbapadawan
    • Thread
    • multiple criteras multiple sheets looping multiple workbook search return results
    • Replies: 1
    • Forum: Excel Questions
  5. C

    VLOOKUP formula issue - need to copy down rows w/o one value changing

    I have an Excel 2007 spreadsheet with a worksheet “Verified” and worksheet6, that I will update based on information on SharePoint site being up to date. I have the formula working but if I copy it down the worksheet, the Value presented is #N/A. When copying the formula the values increase by a...

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