Home |
Search |
Today's Posts |
#1
|
|||
|
|||
lookup
learnt lots from these pages and now have formulas doing all my results, but
i can't find a way to auto my entries. i have 900 students with a larges number entering say the athletics. column A first; B surname; C house; D grade; E gender; F 100m to Q discus. i put a 1 in the events they enter. i then filter say junior girls discus and copy to appropriate form on the discus sheet. its time consuming and the whole process has to be redone if i have to accept late entries. i have tried vlookup with if. index and row but i can't get anything to work. is it possible say from the junior girls discus form to have formula to automatically have first, surname and house listed on the form? Would love to know if possibe? thx. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Lookup Lookup | Excel Worksheet Functions | |||
Lookup Function Problem | Excel Discussion (Misc queries) | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
Excel Lookup Functions | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |