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
- Tmobile data check - Guide
- How to delete part of a table in word - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- School time table software free download full version - Download - Organisation and teamwork
- Gta 5 data download for pc - Download - Action and adventure
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
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