| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup/ match or other function??
Hi!
I'm having some difficulties with finding the right formula (probably a combination of several functions) as I would like to obtain a formula, which will not only vlookup according to one lookup value (in this case a row label) but also according to specific column label. The thing is that I'm looking for some standar formula, which will enable me to return the correct data, as worksheets differ from time to time - some have different rows (Peter, Steve, Olga/ the other time Olga, Kate Betty). The same happens with columns (one time it starts with X, the other time it starts with Z and does not include P). Would anyone be able to help me? I would be glab, as I really can not solve it myself :( X Y Z P O Peter Caroline 3 Steve Olga Kate 4 Betty Z O Y Caroline 3 8 5 Kate 4 6 0 Betty 7 2 1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| MATCH function in a VLOOKUP | Excel Worksheet Functions | |||
| Match as well as does not match array function | Excel Discussion (Misc queries) | |||
| Function Vlookup, Match or Index? | Excel Worksheet Functions | |||
| Function Vlookup, Match or Index? | Excel Worksheet Functions | |||
Threaded Mode
