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 January 16, 2023 - Nov 12, 2018 at 11:39 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Nov 12, 2018 at 11:39 AM
Related:
- Picking data from a table
- Transfer data from one excel worksheet to another automatically - Guide
- Excel data validation list from table multiple columns - Guide
- Html table size to fit window - Guide
- Time table software free download full version - Download - Organisation and teamwork
- Digital data transmission - Guide
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
547
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