Results 1 to 6 of 6

Vlookup returning #N/A

Threaded View

Clash Vlookup returning #N/A 10-03-2007, 05:24 PM
VBA Noob Your range has 3 columns (Col... 10-03-2007, 05:35 PM
Clash VBA, sorry about the... 10-03-2007, 05:45 PM
VBA Noob Change the 5 to 1 as the... 10-03-2007, 05:48 PM
Clash I have attached a quick file... 10-03-2007, 06:04 PM
VBA Noob You need to match the lookup... 10-03-2007, 06:14 PM
  1. 10-03-2007, 05:24 PM #1
    Clash is offline
    Forum Contributor
    Join Date
    01-25-2005
    Location
    Cardiff, Wales
    MS-Off Ver
    Mac 365 & M/S 365
    Posts
    107

    Vlookup returning #N/A

    Hi all,

    I'm using excel 2007 (but this shouldn't be an issue), I have created an unique ID for each of my Customers on "Customers table".

    I want to look at the table and place in another table all the most important info on each customer e.g.

    customer id Address Last Order Price

    The sells info is on the sales table, so I want to lookup customer id on first table and get the sell data from the second table.

    I tried =VLOOKUP(A1,'customer table!'A1:C45,5,False)

    A1 is the customer id and 5 is the column number which could return the address, but all I'm getting is the return #N/A.
    Last edited by Clash; 10-03-2007 at 05:32 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1