Retrieving data from a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have data in a table and would like to retrieve it from a column figure
derived from one cell and a row figure from a second cell. Basically, enter
the table with a column request from one cell and a row request from another
cell and display the intersecting value in the table in a third cell. Hope
this makes sense.

John in PA
 
Gary has provided a way if the values (row/column requests) are 'random'
values, but if they are actual row and column number references then you can
either use INDEX or OFFSET.
Assume your array of data to look into is in B3:F12
your row # is in F16, your column number in G16
=INDEX(B3:F12,F16,G16)
or
=OFFSET(B3,F12-1,G16-1)
both will return the same value from the data array.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Retrieving multiple rows of data 2
how to return an address from a lookup into a table? 7
retrieve data item in terminal cell 2
Retrieving info from multiple tables 1
Multiple formula parts and utilizing a table 4
Retrieving data from one spreadsheet to another. 2

Back
Top