LinkBack URL
About LinkBacks
Under the movement tab how do I get L2 and L3 to show 1234 from the PR tab? After the 100 is received in D4 of the movement tab
Under the movement tab how do I get L2 and L3 to show 1234 from the PR tab? After the 100 is received in D4 of the movement tab
Last edited by bradyman699; 11-25-2016 at 02:36 AM.
Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Thanks!
Maybe this in L2 copied down:
=IF(D2>=100,VLOOKUP(A2,PR!$A$1:$J$2,7,0),IF(I2<=J2,IF(LEN(VLOOKUP(A2,PR!$A$1:$J$2,6,0))=0,"",VLOOKUP(A2,PR!$A$1:$J$2,6,0)),""))
Last edited by AliGW; 11-25-2016 at 02:30 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Just change highlighted 6 into 7
=IF(I2<=J2,IF(LEN(VLOOKUP(A2,PR!$A$1:$J$2,6,0))=0,"",VLOOKUP(A2,PR!$A$1:$J$2,6,0)),"")
Try
L2=IF(I2<=J2,IF(LEN(VLOOKUP(A2,PR!$A$1:$J$2,7,0))=0,"",VLOOKUP(A2,PR!$A$1:$J$2,7,0)),"")
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
I think you can another column after L and use vlookup formula.
or maybe you can give an example the data you want to achieve.
That didn't work. In the entire L column (movement tab) I want the formula to lookup cell F2 (PR tab) and return that number in column L but when the 100 is received in cell D4 (movement tab) I want the same formula to then return the number in G2 (PR tab), which its not doing in L2 and L3
Last edited by bradyman699; 11-25-2016 at 02:56 AM.
Try this in L2, copied down:
=IF(K2="","",VLOOKUP(A2,PR!$A$1:$J$2,6+COUNTIF($D$2:D2,">0"),0))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Thank you for trying but that doesn't work either, I need column L to be
L2:L3 should be 1234
L5:L21 should be 11101045
L4 and L22:L24 should be empty
I don't understand the logic of what you want... but this gives you the result you wanted....
=IF(K2="","",VLOOKUP(A2,PR!$A$1:$J$2,6+1-COUNTIF($D$2:D2,">0"),0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks