+ Reply to Thread
Results 1 to 2 of 2

VLOOKUP Formula to Update Map and Code based on Site name and site ID

  1. #1
    Registered User
    Join Date
    12-09-2020
    Location
    london
    MS-Off Ver
    Office 365
    Posts
    19

    VLOOKUP Formula to Update Map and Code based on Site name and site ID

    Hi,

    I am hoping someone can help with my query.

    I have two tabs in my spreadsheet, site and list.

    I need the site tab populated with the map and code from the list tab, based on using the site name and site ID.

    e.g

    Old Road for unique site 1 would populate cell C & D with the map number and code. I have shown an example answer in the spreadsheet

    I believe a v lookup may be required to address this.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    24,308

    Re: VLOOKUP Formula to Update Map and Code based on Site name and site ID

    In C2 (non-365)

    =IFERROR(INDEX(List!C$2:C$100,AGGREGATE(15,6,ROW($A$1:$A$100)/(List!$A$2:$A$100=$A2)/(List!$B$2:$B$100=$B2),1)),"")

    Copy across and down

    and try this one (365) you were given in an earlier post which you said did not wok but you offered no explanation as to why

    =INDEX(List!C:C,MATCH(A2&"^^"&B2,List!A:A&"^^"&List!B:B,0))

    Normal entry

    this non-365 version works

    =INDEX(List!C:C,MATCH(A2&B2,List!A:A&List!B:B,0))

    with Ctrl+Shift+Enter

    So I cannot see why the 365 version does not
    Last edited by JohnTopley; 03-15-2022 at 06:07 AM.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. V Lookup formula to capture site code against a site name
    By gcolegcole42 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-03-2022, 12:50 PM
  2. Replies: 2
    Last Post: 01-28-2022, 08:41 AM
  3. [SOLVED] Formula to Extract site code from text string
    By bbeards in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-24-2020, 01:37 PM
  4. Automatic update of spreadsheet from web site
    By DougieJLockhart in forum Excel General
    Replies: 2
    Last Post: 05-20-2019, 03:36 AM
  5. Online update from a web-site
    By gkhnr10 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-19-2014, 11:40 AM
  6. Site to Site concurrent call calculation
    By msknja in forum Excel General
    Replies: 5
    Last Post: 08-29-2010, 08:34 PM
  7. i made site! Good Site. Look now mysite!!!
    By joks3xxx in forum Excel General
    Replies: 0
    Last Post: 08-10-2006, 03:47 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1