Match value return a text

P

ppp

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
 
P

ppp

Hi

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

Jacob Skaria

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
 
J

Jacob Skaria

Please ignore my second post...

Jacob Skaria said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
With F1 value, look at A, if match or partial match return B 5
If, Lookup, Match or a combination of all 3
Match and delete rows on two different sheets from reference numbers 4
Lookup 2nd & last match with two conditions 6
Figuring out a lengthy formula. Probably quite simple... 3
Criteria to return maximum value where x = x 3
Refernce 2 sheets & same columns & rows 8

Top