Results 1 to 2 of 2

Thread: Lookup data from another tab
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular Shazz's Avatar
    Join Date
    Oct 2010
    Posts
    136
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Lookup data from another tab

    Hi All, I have data in the following columns on Sheet 2, On Sheet 1 I want to Type the Name in A42 and have the data in Sheet 2 in Column B show in A43 and the data in Sheet 2 in Column C show in B43.

    Column A = Name
    Column B = Title
    Column C = Location

    Can anyone help please.

    Shazz
    x

  2. #2
    Board Regular steve the fish's Avatar
    Join Date
    Oct 2009
    Location
    Midlands, UK
    Posts
    7,643
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Lookup data from another tab

    VLOOKUP will do what you want, eg:

    =VLOOKUP(A42,Sheet2!$A:$C,2,0)

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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