Excel - how can i reference a table using vlookup?

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

Guest

I have a matrix - 6 x 8 with data and headings on the x and y axes; I need to
be able to uniquely identify a cell to be able to use that value somewhere
else.
 
=Index(A1:H6,Match("columnAVal",A1:A6,0),Match("Row1Val",A1:H1,0))

Assumes headings/labels are in row1 and column A.
 
You must log in or register to reply here.

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

Excel automation, change Category (X) Axis Labels, VB6 1
Creating Charts using VBA 0
Can I write a function like matrix function? 2
Help with forcing chart axes scale 1
Excel VBA help: Text file formatting 19
Extracting Data From a Chart 1
Scatter plot / Data from matrices? 1
Copy Sheets to RAM and back 5

Back
Top