Match value return a text
 

i need a formula in Sheet 2 of Column B to return the appropriate match
category based on value in sheet 2 column A


Sheet 1
Column A
a
b
c
d
e
etc

Sheet 2
Column A
1
1
1
2
3
4
5

i need to create column B in sheet 2 which look like the example below

column A Column B
1 a
1 a
1 a
2 b
3 c
4 e
5
6 d

Thanks very much for taking a look and help.

ppp

Match value return a text
 

Hi,

Try this

=INDEX(Sheet1!$C$3:$C$7,Sheet2!D4,1)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"ppp" wrote in message
...
i need a formula in Sheet 2 of Column B to return the appropriate match
category based on value in sheet 2 column A


Sheet 1
Column A
a
b
c
d
e
etc

Sheet 2
Column A
1
1
1
2
3
4
5

i need to create column B in sheet 2 which look like the example below

column A Column B
1 a
1 a
1 a
2 b
3 c
4 e
5
6 d

Thanks very much for taking a look and help.

ppp

Match value return a text
 

Hi

I try the formula you gave me but the return text doesn't appear in the
correct position.

"Ashish Mathur" wrote:

Hi,

Try this

=INDEX(Sheet1!$C$3:$C$7,Sheet2!D4,1)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"ppp" wrote in message
...
i need a formula in Sheet 2 of Column B to return the appropriate match
category based on value in sheet 2 column A


Sheet 1
Column A
a
b
c
d
e
etc

Sheet 2
Column A
1
1
1
2
3
4
5

i need to create column B in sheet 2 which look like the example below

column A Column B
1 a
1 a
1 a
2 b
3 c
4 e
5
6 d

Thanks very much for taking a look and help.

ppp

Match value return a text
 

Try
=INDEX(Sheet1!A:A,A1,1)

If this post helps click Yes
---------------
Jacob Skaria


"ppp" wrote:

i need a formula in Sheet 2 of Column B to return the appropriate match
category based on value in sheet 2 column A


Sheet 1
Column A
a
b
c
d
e
etc

Sheet 2
Column A
1
1
1
2
3
4
5

i need to create column B in sheet 2 which look like the example below

column A Column B
1 a
1 a
1 a
2 b
3 c
4 e
5
6 d

Thanks very much for taking a look and help.

ppp

Match value return a text
 

Hi,

It should. I tried it and got the answer as a,a,a,b,c,d,e. Please check
once again.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"ppp" wrote in message
...
Hi

I try the formula you gave me but the return text doesn't appear in the
correct position.

"Ashish Mathur" wrote:

Hi,

Try this

=INDEX(Sheet1!$C$3:$C$7,Sheet2!D4,1)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"ppp" wrote in message
...
i need a formula in Sheet 2 of Column B to return the appropriate match
category based on value in sheet 2 column A


Sheet 1
Column A
a
b
c
d
e
etc

Sheet 2
Column A
1
1
1
2
3
4
5

i need to create column B in sheet 2 which look like the example below

column A Column B
1 a
1 a
1 a
2 b
3 c
4 e
5
6 d

Thanks very much for taking a look and help.

ppp

Match value return a text
 

In sheet2 Cell B1
=INDEX(Sheet1!A:A,ROW())

'to handle blank entries
=IF(INDEX(Sheet1!A:A,ROW())="","",INDEX(Sheet1!A:A ,ROW()))

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Try
=INDEX(Sheet1!A:A,A1,1)

If this post helps click Yes
---------------
Jacob Skaria


"ppp" wrote:

i need a formula in Sheet 2 of Column B to return the appropriate match
category based on value in sheet 2 column A


Sheet 1
Column A
a
b
c
d
e
etc

Sheet 2
Column A
1
1
1
2
3
4
5

i need to create column B in sheet 2 which look like the example below

column A Column B
1 a
1 a
1 a
2 b
3 c
4 e
5
6 d

Thanks very much for taking a look and help.

ppp

Match value return a text
 

Please ignore my second post...

"Jacob Skaria" wrote:

In sheet2 Cell B1
=INDEX(Sheet1!A:A,ROW())

'to handle blank entries
=IF(INDEX(Sheet1!A:A,ROW())="","",INDEX(Sheet1!A:A ,ROW()))

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Try
=INDEX(Sheet1!A:A,A1,1)

If this post helps click Yes
---------------
Jacob Skaria


"ppp" wrote:

i need a formula in Sheet 2 of Column B to return the appropriate match
category based on value in sheet 2 column A


Sheet 1
Column A
a
b
c
d
e
etc

Sheet 2
Column A
1
1
1
2
3
4
5

i need to create column B in sheet 2 which look like the example below

column A Column B
1 a
1 a
1 a
2 b
3 c
4 e
5
6 d

Thanks very much for taking a look and help.

ppp