View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken Ken is offline
external usenet poster
 
Posts: 590
Default 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