close

I am having a problem sorting a spreadsheet that uses the following formula:

=IF(ISNA(VLOOKUP(ET$6amp;ThisSheet!$D8,'NextSheet'!$A $2:$D$3000,4,
FALSE)),0,VLOOKUP(ET$6amp;ThisSheet!$D8,'NextSheet'!$ A$2:$D$3000,4, FALSE))

When I attempt to sort, the sheet, it puts the items in the correct order,
but the sort criteria no longer corresponds to the reference column.

For example, if the original data was:

C 2
A 3
B 1

If I sort by the first column, it will be sorted correctly (A, B, C), but
the values from the second column no longer correspond, e.g.,

A 2
B 1
C 3

Where am I going wrong?

Thanks.

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()

E-mail轉寄