| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I find a cross reference value
I am trying to lookup data within a spreadsheet using cross references, for
example look down column B and across row 3 to find the value in the cross refrenced cell. I have tried to adopt the LOOKUP function to no avail. Any help would be great, i'm sure it's just a really straight forward formula Many thanks |
|
#2
|
|||
|
|||
|
Hi
try something like =INDEX(A1:G20,MATCH(row_lookup_value,A1:A20,0),MAT CH(colummn_lookup_value,A1:G1,0)) "Jo Davis" wrote: I am trying to lookup data within a spreadsheet using cross references, for example look down column B and across row 3 to find the value in the cross refrenced cell. I have tried to adopt the LOOKUP function to no avail. Any help would be great, i'm sure it's just a really straight forward formula Many thanks |
|
#3
|
|||
|
|||
|
try using MATCH to find the row and then OFFSET or INDEX to complete the
formula -- Don Guillett SalesAid Software "Jo Davis" <Jo wrote in message ... I am trying to lookup data within a spreadsheet using cross references, for example look down column B and across row 3 to find the value in the cross refrenced cell. I have tried to adopt the LOOKUP function to no avail. Any help would be great, i'm sure it's just a really straight forward formula Many thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell reference in a formula is called | Excel Discussion (Misc queries) | |||
| cannot find database | Links and Linking in Excel | |||
| how to cell reference a Chart title | Charts and Charting in Excel | |||
| 3 cells are named - how to refere to them in one reference field in a chart | Charts and Charting in Excel | |||
| Find duplicates | Excel Discussion (Misc queries) | |||
Linear Mode
