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

1. ## 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. ## 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

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

#### 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