VLOOKUP - I THINK I NEED SOMETHING MORE

[HAWK]

CURRENT FORMULA:
=IF(ISNA(LOOKUP(B19,$N$16:$S$34)),"",LOOKUP(B19,$N$16:$S$34))

I NEED TO EXPAND ARRAY TO 60 ROWS. IT WOULD
BETTER IF I DID NOT HAVE TO SORT FIRST ROW IN NUMBERICAL ORDER. THIS IS FOR A SHIPPING DOCUMENT - WE ENTER INVENTORY ITEM # INTO B19
I WOULD LIKE TO SORT ARRAY BY PRODUCT DESCRIPTION (COLUMN S)

I AM LOOKING FOR AN ALTERNATE FORMULA

I APPRECIATE ANY HELP. THANK YOU IN ADVANCE
FOR YOUR TIME.

 

[Anne Troy]

See MyVlookup at:

http://www.thewordexpert.com/tipwarez.htm

It explains the true/false argument that does not require you to sort...

 

[Ricky Morris]

Try using the false parameter in the vlookup function to avoid sorting your lookup table.

ex: vlookup(value,table,3,false)

 

[Anne Troy]

PS: Hawk. Also check out how I use named ranges for my lookup areas. No need to change data range when you use named ranges for entire rows or columns.

 

[Jack in the UK]

Hi Dreamboat

Can i suggest posting the answer rather that just pasting a shortcut hyper link to you home page, guys are asking questions and so would be nice if that answer was on this site for us all to see and use.

And so others can search....

 

[Dave Hawley]

Hi Hawk

In addition to the inforamtion already supplied (in particular the False argument for VLOOKUP). Consider using a COUNTIF to test whether the content of B19 is within your data table.

=IF(COUNTIF($N$16:$N$34,B19)=0,"",LOOKUP(B19,$N$16:$S$34,FALSE))