•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How do I retrieve data point from two cross references?
Our take
Retrieving data points from two cross-referenced sheets can feel challenging, but with the right approach, you can simplify the process. To match a name from Sheet2, column C, and a number from Sheet2, column B, with corresponding values in Sheet1, you can use the XLOOKUP function. This will allow you to search for the name in Sheet1, column C, and the number in Sheet1, column B, to return the hours listed in Sheet1, column D.
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...
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- 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]
- Am I not using XLOOKUP correctly? And absolutes $shttps://imgur.com/a/o0alvvv I am basically trying to get column "E" (Billing End) on the "Upload sheet" to populate with the values found in column "C" on the "Data sheet"...ONLY IF the values in Data Sheet (B:B) and Upload Sheet (C:C) match AS WELL AS Data Sheet (D:D) and Upload Sheet (B:B) match. Sorry, I could have organized the columns more alphabetically but I figure you'd get the gist of it and I can play around with the figures. In Upload sheet E2 and pulling formula down, I would put... XLOOKUP(1, ('Data sheet'!D$2:D$7=B2)*('Data sheet'!B$2:B$7=C2), 'Data sheet'!C$2:C$7, "" ) submitted by /u/jwnsfw [link] [comments]
- I need to return the data from a cell, but the cell to identify where the data is stored movesSo I have the below data returned from a time clock in system. Ill be pulling this data in to a master sheet from a folder, and then subsequently pulling in the newest report stored into the folder there after. I need to be able to return in a separate sheet the id number accompanied by the total hours for the individual. So it would read like this. ID HRS 3 15 4 28.45 5 41.77 The Total Hours column row and ID row will differ report to report due to clocking in and out for breaks and not so no way to hard code the data to a cell. Im not amazing with power query and wondered if that would be able to solve my issues but i cant think of any excel function that will be able to do what i require it to do. Any help https://preview.redd.it/0hz7vh5yaksg1.png?width=748&format=png&auto=webp&s=a1cda5e0e088a18f37ca82eb3c14122becd8659c submitted by /u/Unlikely-Two-8412 [link] [comments]
- Matching Numeric Data across two columns?What I thought would be a simple formula has taken me over 2 hours of searching and no results as yet.. So im reaching out for help please. Heres where Im at. - Using 16.108.2 version - I have 2 sets of data of differing row amounts. There is one numeric column in each set that definitely has matching numbers across them. I need to see which numbers are matching and which numbers aren't. - I need to align those 2 columns where the numbers are matching, and also keep all other information aligned across the columns that are alongside the 2 I am matching. I have tried the XLOOKUP formulas that I can see listed when i do a google search, but i cant get it to work, either some information or step is being left out, or I am finding the wrong info on how to do this. Can anyone provide a step by step on this please? submitted by /u/Sentallmentall [link] [comments]