I have a table in excel that I want to populate from another sheet. I am using the following formula, but I want it to find the next value and then the next value after that and so on. =IF($A$2="","",VLOOKUP($A$2,'D23'!$A$2:$C$255,2,FALSE)). This will only bring up the first time it sees the value in A2. I need it to find the second, and third and such. Please help. I hope this is an easy fix and I'm just drawing a blank. Thank you in advance for you help!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Find next value.
- Thread starter ryokahn
- Start date
Similar threads
