Home |
Search |
Today's Posts |
#13
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Peter Atherton wrote:
Just a point when using VLOOKUP the parts must be arranged in alphbetical order. If they are not sorted then MATCH needs to be included in the formula. No it doesn't, that's what the fourth argument is for, 0 = not ordered, 1 = ordered. Regards, -- Beto Reply: Erase between the dot (inclusive) and the @. Responder: Borra la frase obvia y el punto previo. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
comparing 2 sheets | Excel Discussion (Misc queries) | |||
Comparing 2 sheets | Excel Discussion (Misc queries) | |||
Sheets comparing | Excel Worksheet Functions | |||
comparing 2 sheets | Excel Discussion (Misc queries) | |||
comparing sheets | Excel Programming |