Can't paste list in a different range

Hi everyone,

So I'm trying to use an IF statement to copy a certain list onto the "value if true" part". But since this list has a different range, the values I get are not in order of the list.

Is there a way to get the values in order on excel?


EG:

russian problem.png

Now I'm trying to use the IF formula (in the C column) as such: IF(B:B="A",A:A,""). But using this formula I only get 1, 3 , 8. Is there a way for excel to select them in order so I end up getting 1, 2, 3 etc?

Hope the explanation was clear, if not, please ask!

Need help on this ASAP please!

EDIT:

Thanks for your replies! Many of you are suggesting to use a CountIf Function but this is the problem with that:

This will only work if the list is 1,2,3 etc though. I had suggested this to simplify the problem. I have loads of data (thousands of rows) on several pages. I'm going to be using the is statement something like this in reality: =IF(A:A=0,Sheet2!A:A,""). I have managed to use the IF statement to copy out a column of 0's spaced out the same as the "destination" column. Now I am using the 0's as the "destination" and if there is a 0 present (ie a value is required to be pasted), then excel should copy out (in order) the list on Sheet2 A:A, otherwise leave it blank.

Hope this explains it a bit better

I have attached a sample file below, pls try to use it and see if you can figure something out

Hi, welcome to the forum

Regular IF statements only evaluate 1 condition. B:B is not a 1 condition, it is a range.

I suggest that you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

Hi avkitb,

Looks like you need a CountIf Function with a dollar sign on the top row. See the attached.

CountIf not blank.xlsx

Try this in C3, copied down...
=IF(B3="a",MAX($C$2:C2)+1,"")

Here is another 1...
=IF(B3="A",COUNTIF($B$3:B3,"A"),"")

Have you considered swapping the "A" for a cell-ref, instead?
=IF(B3=$C$1,MAX($C$2:C2)+1,"")
=IF(B3=$C$1,COUNTIF($B$3:B3,$C$1),"")

If that still doesnt work, please provide a more representative sample of what you are working with - and what you want.

I think my attached example above does what you want.

It looks like you want a different text each time a certain phrase if shown in A?

If so, create a list, numbered 1 to however many texts you have, such that each text has it's own unique number...

Lists sheet

	A	B
1	1	"???? ??????"
2	2	"?? ??????? ??????"
3	3	"?????? ???????????? ?? ???????? ??? ??????????? ?????? ? ??? ???????? ?????? ? ????? ????????????".
4	4	"?? ??????????? ????? ???????? ??? ????? ???????".
5	5	"% ??????? ? ?????????"

Then put this in C1 and copy down...
=IF(A1="","",VLOOKUP(COUNTIF($A$1:A1,A1),list!$A$1:$B$5,2,0))

This is based on the COUNTIF counting how many times teh entry in A appears, so you may need 2 list s, 1 for msgid and 1 for msgstr