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.