User Profile
Henning4240
Copper Contributor
Joined Mar 08, 2022
User Widgets
Recent Discussions
VLOOKUP problem Values in column A from retrieving documents shifts place!!!
Hi All. I have 2 documents; 1 with basic data for varous items and 1 to retrieve these data used as order sheet. The data-file has lines like this: *2001444* 2149 010 2 Quick Schelle M20 clips til rør M20 *2001445* 2149 022 2 Quick Schelle M32 Clips til rør M32 *2001446* 2149 028 2 Quick Schelle M40 Clips til rør M40 *2001437* 58623011 2 led signalleuchteEBD 22mm rot Led signal lampe rød wheras the first column is a fixed number. I'm using the VLOOKUP to retrieve these lines into an ordersheet, (sorry for the danish version) =LOPSLAG($AA20;'[lagerliste stregkode.xlsx]Lagerliste udfyld her'!$A$1:$Q$646;5;FALSK) which should return like this: 20014458 2 Clips til rør M32 2149 022 Quick Schelle M32 My problem is, tha the values in column A in the data-sheet, changes from the rest of the line data (e.g. *2001444* is in row 48, but next time i look, it is in row 52 and therefore reurns wit the values from that row.) Is there someway i can make sure, that all values in a row are fixed to another, even after sorting columns?533Views0likes0Comments
Recent Blog Articles
No content to show