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
|