| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Referencing Cells Using If Functions
Example:
I have 2 adjacent columns of cells (A&B), each with thousands of different values in them. I have a known value (C1) which also exists in one of the cells of the range of values in (B). If, hypothetically, this value in C1 exists in B2304 I want a formula to give me the value in A2304. In other words, D1 = Ax if Bx equals C1 Can someone please help me with this? ) |
|
#2
|
|||
|
|||
|
Try this:
=INDEX(A1:A10000,MATCH(C1,B1:B10000,0)) -- Regards, Dave " wrote: Example: I have 2 adjacent columns of cells (A&B), each with thousands of different values in them. I have a known value (C1) which also exists in one of the cells of the range of values in (B). If, hypothetically, this value in C1 exists in B2304 I want a formula to give me the value in A2304. In other words, D1 = Ax if Bx equals C1 Can someone please help me with this? ) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing cells containing tab names? | Excel Worksheet Functions | |||
| Help me! There is problem with cells view... | Excel Discussion (Misc queries) | |||
| Referencing cells text output if it meets specific conditions | Excel Worksheet Functions | |||
| Plotting blank cells that have functions in them. | Charts and Charting in Excel | |||
| copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions | |||
Linear Mode
