D
Derek Wittman
I have a data table that has a field with a formula that includes multiple
vlookups and multiple tabs (the array is on a worksheet tab). The lookup
value is another cell in the record and that's compared to a value in the
array. I'm not using absolute references in the lookup value because I'm
checking each record/row in the data table. but I AM using absolute refs in
the array (because we don't want each row to advance to a different area of
the reference array)...
Is there another way to lookup, but not lose my lookup value when I resort
the table?
Thank you!
Derek
vlookups and multiple tabs (the array is on a worksheet tab). The lookup
value is another cell in the record and that's compared to a value in the
array. I'm not using absolute references in the lookup value because I'm
checking each record/row in the data table. but I AM using absolute refs in
the array (because we don't want each row to advance to a different area of
the reference array)...
Is there another way to lookup, but not lose my lookup value when I resort
the table?
Thank you!
Derek