Thanks:  0
Likes:  0

# Thread: VLOOKUP - I THINK I NEED SOMETHING MORE

1. 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

2. See MyVlookup at:

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

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

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

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

4. 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.

5. 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....

6. 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))

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•