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?
