LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 28
Default Cell reference from 2 Lookups

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formulas that reference cells that reference another cell Andrea Excel Discussion (Misc queries) 7 October 19th 06 08:14 AM
absolute cell reference A spreadsheet cell reference that does no help Excel Discussion (Misc queries) 1 January 18th 06 06:56 PM
LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied. Mr Wiffy Excel Worksheet Functions 2 May 16th 05 04:29 AM
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. [email protected] Excel Worksheet Functions 2 December 11th 04 12:05 AM
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable [email protected] Excel Worksheet Functions 2 December 11th 04 12:00 AM


All times are GMT +1. The time now is 11:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"