Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup or Other vs Sort?
Excel 2003 ... What I have
Range A4:A103 ... ascending values 1, 2, 3, to 100 Range B4:J103 ... unique line-item records Range K4:K5003 ... ascending values 1, 2, 3, to 100 (each repeat 50 times) Range L4:T5003 ... I need a formula to return each of the line-item records contained in Range B4:J103 (each 50 times) I am using a VLOOKUP formula with a chg to return Col only, but I am having the following issues: =VLOOKUP($K4,$A$3:$J$5003,4,0) ... returns "0" when an empty cell is found (I do not wish to see a "0" ... I want an empty cell) ... so I started using =if(VLOOKUP($k4,$A$3:$J$5003,4,0)="","",VLOOKUP($K 4,$A$3:$J$5003,4,0)) ... Looks great, but now my "Sort" fails as the "" found in the cell ends @ the top ... I wish it to be @ bottom. If I then Filter Blanks, Clear Contents, Show ALL, & re-sort all is fine. What do I need to do here? My "Thanks" in advance to those of you that are intimate with Excel & support these boards ... Kha |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sort when using VLOOKUP | Excel Worksheet Functions | |||
vlookup and sort error | Excel Worksheet Functions | |||
Sort of VLOOKUP | Excel Worksheet Functions | |||
Vlookup, Sort ?? | Excel Discussion (Misc queries) | |||
Sort with ISNA and vlookup | Excel Worksheet Functions |