UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Index/match, Office 2013    
 
   
tpitman
post Mar 13 2017, 08:28 AM
Post#1



Posts: 543
Joined: 20-June 04
From: UK


Hi,

I have a workbook which contains 2 worksheets

Chamber Info
User Info


User Info:

Column B = Name (B3:B500)
Column C = email (C3:C500)
Column D = Contact No. (D3:D500)


Chamber Info:

Column C drop down list of the users in 'User Info'


When a name is selected from the list, I would like the respective info from (User Info) Columns C & D to go into (Chamber Info) Column D & E, but I'm not sure how to use INDEX/MATCH?
Go to the top of the page
 
post Mar 15 2017, 08:26 AM
Post#2








Try this array:

In cell D4 of Chamber Info put this formula:

=IFERROR(INDEX(User Info!C$3:C$500,MATCH($C4,User Info!$B$3:$B$500,0)),"")

Press CTRL+SHIFT+ENTER to make it an array. Then drag it over to column E then drag it down your range.

It will have curly brackets around the formula showing it is an array.

Good luck with your project!
This post has been edited by billgyrotech: Mar 15 2017, 08:30 AM
Go to the top of the page
 
tpitman
post Mar 24 2017, 08:28 AM
Post#3



Posts: 543
Joined: 20-June 04
From: UK


Sorry for the late response!

I now have it working. :-)

Go to the top of the page
 
post Mar 24 2017, 09:02 AM
Post#4








Glad to help!
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    16th August 2017 - 08:32 AM