Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

EXCEL Vlookup across different tabs???

  • 29-03-2010 02:11PM
    #1
    Closed Accounts Posts: 39


    Hi ppl,

    I using excel 2003 and want to use vlookup to pull some info from one tab to another???

    I have two tabs [named "tab1" & "tab2"] with similar information, However the tab i want to poupulate needs some work!!!!.

    In both tabs I have the same identical colum with 'tag numbers' for example "p-4001A" 0r "k-3001B" . In the "tab1" i want to populate i am missing a 'serial 'which is on tab2..... I think vlookup is the way to go

    The sheet is over 1000 rows long,

    Could anyboby please point me in the right direction??? Thanks


    lw


Comments

  • Closed Accounts Posts: 31 mmcm888


    Vlookup is what you need

    Assume that TAB1 has the 'tag' in column B
    Assume that TAB2 has the 'tag' in column A and the value you ant to put into TAB1 in column C

    VLOOKUP(b1,TAB2!$A$1:$c$999,3,FALSE)

    In english
    Vlookup the value in cell B1 in the range(array) $A$1 to $c$999 and return the value in the third column of the array. If FALSE is specified only match exactly (otherwide Excel will do a best macth whatever that might be)

    make sure you use $ (absolute) references for the array being looked up.

    Hope this helps.

    M.


Advertisement