cross referance

  1. S

    Compiling weekly numbers from same column, cross referencing serial numbers,zones, tasks and dates in other columns.

    Hi, I've built a barcode scanning system to keep track of what files and boxes are being worked on through the process. I use VBA and in cell formulas and the database is just an excel table. I need to do a weekly summary of how much progress has been done daily (the difference between the...
  2. R

    Cross search matching data

    My employer asked me to automate the duplicate positioned items in excel. Our company works with 20.000+ items and the stock in all of the locations is automatically updated each day. When new items are moved by a branch, they often forget to remove the replaced item out of our database. The...
  3. C

    Return cell value based of row Named Range and Column Named Range

    Hi All I want to return the cross reference of 2 named ranges. There is a sheet called Front Page where i want to return the result and the information is on a sheet called Commission Row named range = Partner Column named range = Finance Both of the named ranges will be referenced in as...
  4. C

    cross reference between 2 sheets in same workbook

    I work with audit rules that are being populated from a financial database (Concur) into an excel sheet. There are different rules being applied to different organizations. I need to compare the overall data in sheet2 that has the names of the codes for the organization that are auto populated...
  5. J

    Using an if(match statement?

    Hey guys, what I'm trying to do is the following: I want to make sure that if A1 matches any value within this range B1:B1826 (on a different sheet) then return the column C in that row. For example, if A1=B453 return C453 Any help would be much appreciated! Thank you :)
  6. A

    Timeseries column cross-reference and matching?

    Hello all, I’m a new noob to the forum, would appreciate if anybody could provide some help. I have 5 sets of columns, each includes a Time column and a Price column. However, the 5 individual Time columns of the 5 sets don’t match, i.e, the dates are not continuous (there are...
  7. H

    Cross referance chart formula help

    Hello Experts, I have been working on theis cross referance formula for a while. I now need some help. I may be close but not close enough. This chart is used for a HVAC application. 51 is wet bulb temp, 71 is dry bulb temp, the cross referance would be 21.3. <TABLE style="WIDTH: 147pt...

This Week's Hot Topics

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
Top