| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel - how can i reference a table using vlookup?
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel - how can i reference a table using vlookup?
=Index(A1:H6,Match("columnAVal",A1:A6,0),Match("Ro w1Val",A1:H1,0))
Assumes headings/labels are in row1 and column A. -- Regards, Tom Ogilvy "pt706" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup Using a Reference as a Table Array | Excel Worksheet Functions | |||
| VLOOKUP with Structured Reference to Table Header | Excel Worksheet Functions | |||
| Replacing a Table-array with a cell reference in vlookup | Excel Worksheet Functions | |||
| use cell reference,whose contents= a table array name for Vlookup | Excel Worksheet Functions | |||
| Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
Linear Mode
