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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks