| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
vlookup help...
I have a formula setup to look up a value in another sheet and bring back a
value. Here is my formula in cell J2 =VLOOKUP("PADRES",Scores!K:N,2,0) It works perfectly. However, there will be multiple times Padres shows up in the scores worksheet. How do I setup the formula so in cells J3 it skips the first occurance of Padres and finds the next one. Then J4 finds the 3rd occurance and so on. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array Function with VLOOKUP | Excel Worksheet Functions | |||
| make a vlookup using a variable path | Excel Worksheet Functions | |||
| vlookup data hidden within worksheet | Excel Worksheet Functions | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
| VLOOKUP not working | Excel Worksheet Functions | |||
Threaded Mode
