Picking data from a table
Closed
AdrianHowland
Posts
4
Registration date
Wednesday October 4, 2017
Status
Member
Last seen
November 10, 2018
-
Updated on Nov 11, 2018 at 02:31 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 12, 2018 at 11:39 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 12, 2018 at 11:39 AM
Related:
- Picking data from a table
- School time table software free download full version - Download - Organisation and teamwork
- Transfer data from one excel worksheet to another automatically - Guide
- Tmobile data check - Guide
- Excel data validation list from table multiple columns - Guide
- Html table size to fit window - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Nov 12, 2018 at 11:39 AM
Nov 12, 2018 at 11:39 AM
Hi Adrian,
My understanding of your query is that you have a table with names in row 1 and characteristics in column A. When you put a name in one cell and a characteristic in another cell, you would like to retrieve the matching value from the table.
If this is correct then have a look at the solution below:
Let's say the table has a range from A1 to E5.
You enter the name in J1 and the characteristic in J2.
To get the result from the table use:
=INDIRECT("R"& MATCH(J1,A1:E1) & "C" & MATCH(J2,A1:A5),FALSE)
Best regards,
Trowa
My understanding of your query is that you have a table with names in row 1 and characteristics in column A. When you put a name in one cell and a characteristic in another cell, you would like to retrieve the matching value from the table.
If this is correct then have a look at the solution below:
Let's say the table has a range from A1 to E5.
You enter the name in J1 and the characteristic in J2.
To get the result from the table use:
=INDIRECT("R"& MATCH(J1,A1:E1) & "C" & MATCH(J2,A1:A5),FALSE)
Best regards,
Trowa