•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How do I write this cross reference formula
Our take
If you're looking to streamline your workflow with a cross-reference formula between two columns of part numbers, you're in the right place. In this scenario, you have part numbers in Column A that you need to match against those in Column B, while you want to paste a list in Column C. The goal is to check Column B for matches and return the corresponding part number from Column A into Column D.
I have two columns of part numbers, column a is the part number I need and column b is the part number I'm given. I would like to copy and paste a list of part numbers in column c, have it check column b for any matches and return the associated part number from a into column d. Any solutions?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Comparing columns and extranting a valueI need help (I’m very new to Excel). I need a formula to help me with this: I have a large list of items in column A and corresponding values in column B. Now, in column C, I have a short list that is included in column A. I need a formula to compare columns A and C, and if the values match, then write in column D the corresponding value from column B. submitted by /u/Royal_Instance4497 [link] [comments]
- Two workbooks, two columns in second book could include matching data, neatest most efficient way to query between them on multiple fields using excel formula only, no VBA / Power Query etc?Not even sure how to surmise this but here we go: Workbook 1, column i has a reference code, "EntID" which could be a number OR text. Workbook 2, that reference code might be found in Column A, or Column B, or neither. In Workbook 1, I need 5 lookup columns to pull data from 5 corresponding columns in Workbook 2 where there is a match for " EntID" in EITHER column A or B. If there is no match then the cell should state "Not Found". I have it working by using nested if statements, isnumber & xmatch for the first lookup column to ascertain where the match is found and then xlookups on remaining columns depending on the result returned to that cell but the formula are huge if for no other reason than the file naming and locations (which cannot be changed) and it feels slow, clunky and unrefined. How would you do it? submitted by /u/Delinquent90 [link] [comments]
- How do I retrieve data point from two cross references?Apologies, this may be a softball. My brain is toast. I need to reference a name (in say Sheet2, column C) and a number-entry # (in say Sheet 2, column B) to return the figure (hours - in Sheet 1, Column D) by looking up and matching name to Sheet 1, column C and number-entry# in Sheet 1, column B. This is my home stretch to finish my worksheet, and for some reason I have nothing left in the tank. Any help is greatly appreciated. I dont know if I was using XLookup incorrectly or what... submitted by /u/LogicPrevail [link] [comments]