Forum Discussion
HELP for EXCEL
here is the lionk
https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.dropbox.com%2Fscl%2Ffi%2F541m2a1w3cd0ak1m6t9e8%2FSAMPLE.xlsx%3Frlkey%3Dzlg4e19w56gnfwgjlznrpcpj8%26dl%3D0&data=05%7C01%7CPrinceDarl.Jamisola%40iqor.com%7Cfe32e1171a7b44c5027508dbcb4cd0e9%7C64d057c4c04c46f99cdf1d2ba46b5074%7C0%7C0%7C638327304114416276%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=qcES%2BEJA8mvnJQID%2BcwhLjdOArhMv%2FQCweGB6eHY5fg%3D&reserved=0
See the attached version.
- can you try to put formula to this. i tried your formula but not working.
https://www.dropbox.com/scl/fi/e4q097d1gr7zylc2tazck/1697484979523_sample-file.xlsx?rlkey=u14k0olp7rbbdnor4jlchn6uw&dl=0In the sample workbook that you made available earlier, the PROD RAW sheet had "SAM SMITH" (with a space between first and last name), while the Daily View sheet had "SAM.SMITH" (with a point between first and last name). My formula took that into account.
In your new workbook, both sheets have a point between first and last name, so the formula should be slightly different. In L2 on the Daily View sheet:
=IFERROR(INDEX('PROD RAW'!$K$2:$K$7023,MATCH(1,('PROD RAW'!$A$2:$A$7023=$B2)*('PROD RAW'!$D$2:$D$7023=$E2),0)),"")
HansVogelaar i really appreciate the help.
i provided the actual sample file. i hope you can help me out to put the formula on it.i need to get the value auto of the one encircled in black once i put the name in column E.
the value is located in other sheets with multiple names .Thank you in advance.
Here is the link for the file.
https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.dropbox.com%2Fscl%2Ffi%2Fqzd3fmrbro9f8khr8057u%2F1699285261376_SAMPLE.xlsx%3Frlkey%3D251cnplzx6s6gsrrp61g2vw2m%26dl%3D0&data=05%7C01%7Cprincedarl.jamisola%40iqor.com%7C9a6d192a6bea435ea58808dbdedf3982%7C64d057c4c04c46f99cdf1d2ba46b5074%7C0%7C0%7C638348823667350891%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=b2wbbUzmE7Rrgx3MREaOj7V8a5iIl2r4zDrhSfZw3CM%3D&reserved=0
- https://techcommunity.microsoft.com/t5/excel-blog/what-s-new-in-excel-september-2023/ba-p/3915215 pacheck po ig kaya magawa/
- https://techcommunity.microsoft.com/t5/user/viewprofilepage/user-id/584627can you try to do the am trying your formula but its not working
What exactly is the problem? "The formula is not working" doesn't tell me much.
I modified ever so slightly the formula that my friend, HansVogelaar , had given you. There was a discrepancy in your spreadsheets between how you referred to SAM SMITH, in the PROD RAW sheet you had "SAM SMITH" whereas in the "Daily View" sheet you had "SAM.SMITH" --that oh, so little period between the names.
So HansVogelaar had worked with what you had, and used the SUBSTITUTE function to insert a period in the search criteria. I chose to delete the period and make it "SAM SMITH" in both instances. That also allowed a simpler formula.
IF the period is necessary (which I seriously question) then you should have it both places; if it's not, then in neither. But don't mix them....you're just shooting yourself in the foot.
See the attached and compare this with the original by Hans.
