164 - Inepro Back Office Suite
Configuration
Searching values in Excel
Use when fields from columns are needed to create a new field with the gathered data. In this case make an export from
Users from the Inepro Back Office Manager and compare those records with the table that has the User code and some
other extra field of data and give the matching extra data for that user code.
Use this formula:
=INDIRECT(ADDRESS(MATCH(<SeachValue>;<SearchRange>;<MatchCode
-
Important,
must
be
0!>)
+<Increment>;<ColumnNumberResultValue>))
This formula will find and use only the first result, so make sure the search value is unique.
For example: =
INDIRECT(ADDRESS(MATCH(
D1
;
$B$1:$B$100
;
0
)+
1
;
3
))
Where
D1
is de value searched (ie. the User Code),
$B$1:$B$100
is the location to search (ie. the column with User
Codes in the search range, where $ is used to ensure that the search range remains fixed),
0
is the match code, this
should always be 0 when comparing text fields like this, the increment value is to compensate for an included header row in
the search range that will make the row index too low by one.
3
is the column number A=1, B=2, C=3 etcetera. So we
search column B (numbered from 1-100), but we want the result to be, what is in column C in that same row. (in this
example C is the value of in words).
B
C
D1
Extruded Value
124
One Hundred Twenty Four
124
One Hundred Twenty Four
141
One Hundred Forty One
141
One Hundred Forty One
192
One Hundred Ninety Two
192
One Hundred Ninety Two
In some versions of Excel local keywords are used and statements like 'IF' and 'TEXT' might be different, it can also be
that instead of a " a ' must be used and then the ';' must be replaced with a ','.
Содержание Back Office Suite
Страница 2: ......
Страница 9: ...Introduction PartI ...
Страница 11: ...3 Overview IBOS Overview IBOS ...
Страница 12: ......
Страница 13: ...Hardware Installation PartII ...
Страница 20: ......
Страница 21: ...Software installation PartIII ...
Страница 28: ...20 Inepro Back Office Suite Software installation 9 Select Start Menu Folder Select the Start Menu folder ...
Страница 38: ......
Страница 39: ...Steps PartIV ...
Страница 120: ...112 Inepro Back Office Suite Steps Image 1 Image 2 Image 3 ...
Страница 149: ...Advanced Tasks PartV ...
Страница 152: ...144 Inepro Back Office Suite Advanced Tasks Changing the IP addresses host name of the Database server DocuPRO IBOS ...
Страница 153: ...145 Replacing a server PayCon Server ...
Страница 157: ...Terms Concepts PartVI ...
Страница 159: ...Configuration PartVII ...
Страница 177: ...169 Import Data If the installation was successful the final screen of the installer is shown ...
Страница 179: ...171 Import Data The following screen will appear ...
Страница 206: ......
Страница 207: ...Change Interface Settings PartVIII ...
Страница 209: ...USB Stick Procedure PartIX ...
Страница 211: ...Balance Scheduler PartX ...
Страница 214: ......
Страница 215: ...Scheduled Tasks PartXI ...
Страница 218: ......
Страница 219: ...Troubleshooting PartXII ...
Страница 234: ......
Страница 235: ...Glossery PartXIII ...
Страница 238: ......
Страница 239: ...Appendices PartXIV ...
Страница 244: ...236 Inepro Back Office Suite Appendices ...
Страница 246: ......
Страница 248: ......