| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can I return a cross referenced cell value?
I want to set up a formula in a cell in one worksheet to display the value of
a cell that is the intersect point of known values in two other cells in another worksheet (same workbook). E.g., I know the text values of A10 ("SF") and E1 ("LA") in Sheet1, so I want the formula in K20 on Sheet2 to return the static value of E10 (381), which is the intersect point of A10 and E1 on Sheet1. Thanks for any tips! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| How do I use a function to return the address of a cell? | Excel Worksheet Functions | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| if the value of a cell in a range is not blank, then return the v. | Excel Worksheet Functions | |||
| How to make a cell return the formatted value in a text string (i. | Excel Worksheet Functions | |||
Threaded Mode
