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.

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

    software

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

    E-mail轉寄