loveindia Posted July 19, 2016 Report Share Posted July 19, 2016 Nenu oka tabular model chestunna... SQL Server lo between operator laaga Excel lo ela vaadali ani doubt... scenario is like below.. Sheet 1: EmpID EmpName Date DeptID(CalcualtedColumn) 1 ABC 07/18/2016 (FORMULA) Sheet 2: EmpID StartDate EndDate DeptID 1 01/01/2016 06/30/2016 1 2 07/01/2016 12/31/2016 2 So Sheet 1 lo unna EmpID and Date use cheskoni, sheet 2 lo unna DeptID ni pick cheskovaali... Lookup types lo cheyyali... Normal ga Tabular lo RELATED ani oka keyword undi, I use it by creating a concatenated column and use that similar to a JOIN command in SQL .. (RELATED in DAX == JOIN in SQL) So excel lo kind of VLOOKUP laantidi vaadi emanna idi cheyochaa... don't tell me just use MEDIAN or something... tried many things so far man... if you have anything working, please let me know... SQL lo cheyochu gaa easy ani cheppakandi man... sql lo 1 min task, since I am doing Tabular services, I am keeping away as far as I can from the SQL System, just using it as source of truth for data thats it.... Thanks in advance... Lets do some discussion, if you have the answer.... Calling all Excel Experts, @tom bhayya @Spartan @nissan @ronitreddy @4Vikram Quote Link to comment Share on other sites More sharing options...
Staysafebro Posted July 19, 2016 Report Share Posted July 19, 2016 vlookup Quote Link to comment Share on other sites More sharing options...
loveindia Posted July 19, 2016 Author Report Share Posted July 19, 2016 Just now, Staysafebro said: vlookup ushooooooo.... man painaa vlookup tho work aitey appudu cheppu anna kada man... tried it, didn't work for me man... let me know if you happened to do it man... Quote Link to comment Share on other sites More sharing options...
Spartan Posted July 19, 2016 Report Share Posted July 19, 2016 no videa man.. calling $excel specialist @150bryant @vikuba Quote Link to comment Share on other sites More sharing options...
Staysafebro Posted July 19, 2016 Report Share Posted July 19, 2016 =VLOOKUP(A2,Sheet2!A2:D3,4,TRUE) Quote Link to comment Share on other sites More sharing options...
loveindia Posted July 19, 2016 Author Report Share Posted July 19, 2016 Just now, Staysafebro said: =VLOOKUP(A2,Sheet2!A2:D3,4,TRUE) didn't understand your formula man... How do you know the data is always only upto A2:D3? have you tried something called OFFSET before? that can help with that find... but how will you apply the BETWEEN formula here man.... Quote Link to comment Share on other sites More sharing options...
loveindia Posted July 19, 2016 Author Report Share Posted July 19, 2016 3 minutes ago, Spartan said: no videa man.. calling $excel specialist @150bryant @vikuba Thanks for calling SaaraSooreedu man... Quote Link to comment Share on other sites More sharing options...
tom bhayya Posted July 19, 2016 Report Share Posted July 19, 2016 excel VSD ki chaala dhuram ga untam man Quote Link to comment Share on other sites More sharing options...
loveindia Posted July 19, 2016 Author Report Share Posted July 19, 2016 Just now, tom bhayya said: excel VSD ki chaala dhuram ga untam man only today come here man, from tomorrow no come man... Quote Link to comment Share on other sites More sharing options...
Pehlwan Posted July 19, 2016 Report Share Posted July 19, 2016 21 minutes ago, Staysafebro said: =VLOOKUP(A2,Sheet2!A2:D3,4,TRUE) VLOOKUP(A2,Sheet1!$A$2:$D$<no of lines>,4,False) this should work replace content in sheet1 with sheet 2 and same for sheet2 I believe vlookup picks up only from left side...not sure...but i do it all the time for quarterly chargeback report Quote Link to comment Share on other sites More sharing options...
Batman_fan Posted July 19, 2016 Report Share Posted July 19, 2016 use Excel VBA. Read each row from sheet1 and compare it with sheet2 each row using IF and write to different column. Quote Link to comment Share on other sites More sharing options...
loveindia Posted July 19, 2016 Author Report Share Posted July 19, 2016 2 minutes ago, Pehlwan said: VLOOKUP(A2,Sheet1!$A$2:$D$<no of lines>,4,False) this should work replace content in sheet1 with sheet 2 and same for sheet2 I believe vlookup picks up only from left side...not sure...but i do it all the time for quarterly chargeback report how will this vlookup perform the between of the two dates man? I understand you are doing the EmpID Match but what about the date?? It should fall between the startdate and enddate of the sheet2 man.... Quote Link to comment Share on other sites More sharing options...
loveindia Posted July 19, 2016 Author Report Share Posted July 19, 2016 3 minutes ago, Batman_fan said: use Excel VBA. Read each row from sheet1 and compare it with sheet2 each row using IF and write to different column. I just want to see if I can do that as a formula because I plan to rewrite the same into DAX man.... Quote Link to comment Share on other sites More sharing options...
Pehlwan Posted July 19, 2016 Report Share Posted July 19, 2016 1 minute ago, loveindia said: how will this vlookup perform the between of the two dates man? I understand you are doing the EmpID Match but what about the date?? It should fall between the startdate and enddate of the sheet2 man.... are u trying to get start and dates as well? not sure I understand your question Quote Link to comment Share on other sites More sharing options...
loveindia Posted July 19, 2016 Author Report Share Posted July 19, 2016 Just now, Pehlwan said: are u trying to get start and dates as well? not sure I understand your question Sheet 1 lo EmpID and Date ni use cheskoni, Sheet 2 lo unna EmpID and BETWEEN StartDate AND EndDate between lo aa date (from sheet1) untey appudu it has to give the Dept ID... Quote Link to comment Share on other sites More sharing options...
.thumb.jpg.abf7d08f99d33f7507f9f0e982085cc3.jpg)
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.