LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sort when using VLOOKUP Kathie Excel Worksheet Functions 1 August 6th 08 03:11 PM
vlookup and sort error LiveUser Excel Worksheet Functions 2 November 7th 07 03:41 PM
Sort of VLOOKUP Rob_T Excel Worksheet Functions 6 May 10th 06 01:25 PM
Vlookup, Sort ?? M.A.Tyler Excel Discussion (Misc queries) 6 February 1st 06 02:21 AM
Sort with ISNA and vlookup Tom Excel Worksheet Functions 0 January 26th 06 08:01 PM


All times are GMT +1. The time now is 10:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"