About Us

Gaurav[_5_]

Hi,

What formula do I need to use to accomplish the following.

Lookup some value in another sheet and return the Cell Address(Column and
Row) that has this value.

Thanks in advance.

Mike H

Hi,

It depends on how the data we are looking up are laid out but here's a
simple one

="A" & MATCH(A1,Sheet2!A:A,FALSE)

Mike

"Gaurav" wrote:

Hi,

What formula do I need to use to accomplish the following.

Lookup some value in another sheet and return the Cell Address(Column and
Row) that has this value.

Thanks in advance.

Gaurav[_5_]

Thanks Mike. I have one more question.

How can I use the value returned by this formula in a COUNTIF function. I
mean the formula you just wrote in your reply gives me the row number and
now I want to know how many times a particular value appears in that this
row.

Thanks a ton.

"Mike H" wrote in message
...
Hi,

It depends on how the data we are looking up are laid out but here's a
simple one

="A" & MATCH(A1,Sheet2!A:A,FALSE)

Mike

"Gaurav" wrote:

Hi,

What formula do I need to use to accomplish the following.

Lookup some value in another sheet and return the Cell Address(Column and
Row) that has this value.

Thanks in advance.

Mike H

Hi,

One way

=COUNTIF(INDIRECT("Sheet2!" & MATCH(A1,Sheet2!A:A,FALSE)&":"&
MATCH(A1,Sheet2!A:A,FALSE)),"Myvalue")

All in one line. If you are trying to count number change "Myvalue" to the
number you looking for with no quotes.

Mike

"Gaurav" wrote:

Thanks Mike. I have one more question.

How can I use the value returned by this formula in a COUNTIF function. I
mean the formula you just wrote in your reply gives me the row number and
now I want to know how many times a particular value appears in that this
row.

Thanks a ton.

"Mike H" wrote in message
...
Hi,

It depends on how the data we are looking up are laid out but here's a
simple one

="A" & MATCH(A1,Sheet2!A:A,FALSE)

Mike

"Gaurav" wrote:

Hi,

What formula do I need to use to accomplish the following.

Lookup some value in another sheet and return the Cell Address(Column and
Row) that has this value.

Thanks in advance.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
=HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),QuoteNotes,	sarah	Excel Worksheet Functions	2	February 17th 09 02:59 PM
=HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),Range ... ?	sarah	Excel Worksheet Functions	0	February 17th 09 02:06 PM
Return cell address of a cell based on contents of cell.	Danny	Excel Worksheet Functions	4	November 15th 08 03:11 AM
find last cell in range with data, display cell address	sevi61	Excel Worksheet Functions	14	October 29th 07 08:36 PM
How make hyperlink refer to cell content rather than cell address.	Omunene	Excel Discussion (Misc queries)	3	March 2nd 06 01:07 AM

Menu

About Us