Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Newbie
1. I would like to find a matching number in column C. I want the function to return what row it was found in. 2. I would also like to find a matching number in row 3. I want the function to return what column it was found in. 3. I then want to place a number in intersecting row and column found from #1 and #2 above. Let me give an example: A B C D E F G 1 4 2 8 34 8 9 10 1 2 3 4 10 5 13 6 9 (N) Let's say I want excel to search for the number 1 in row 3. It should return the column it was found in which is E. Let' say I want excel to search column C for the number 9. It should return the row it was found in which is 6. Then I want excel to enter another number let's call it (N) in the column and row it found earlier which is E6. Please help. -- vze2mss6 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied. | Excel Worksheet Functions | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions |