Thanks:  0
Likes:  0

1. My lookup is returning #N/A for some reason

It's looking up the first number of a 4 digit number. some may start with a number some may start with a letter. the letter comes back ok but the number doesn't

Here is my formula =vlookup(left(a3,1),ship,2,0)

Thanks

2. Ensure that criteria cell and Lookup range
are both formatted text before entering
information.

=VLOOKUP(LEFT(A3,1),Ship,2,0)

[ This Message was edited by: Dave Patton on 2002-03-28 19:10 ]

3. Hi lars

Try:

=VLOOKUP(IF(ISERROR(LEFT(A3)*1),LEFT(A3),LEFT(A3)*1),Ship,2,FALSE)

Try also not to form the habit of using Zeros instead of False, it's bad practice. Later when you try and de-bug you will find it hard to determine whether zeros are really zeros or they represent False. It can also lead to problems if you do an Edit Replace for zeros.

4. Good point Dave!
I learnt an additional lesson for no extra charge.

5. Hi Yogi

If you post you mailing address I'll post the invoice

6. It's looking up the first number of a 4 digit number. some may start with a number some may start with a letter. the letter comes back ok but the number doesn't

Here is my formula =vlookup(left(a3,1),ship,2,0)

=VLOOKUP(IF(ISNUMBER(LEFT(A3)+0),LEFT(A3)+0,LEFT(A3)),ship,2,0)

This assumes that the first column of ship is of mixed data type, that is, consists of numeric and text values.

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
•