D
DBuche
I need a function that provides a hot button which will return values but
VLOOKUP may not be powerful enough.
Worksheet 1, named Code List, has two columns. The first column contains a 2
digit code, AP for instance. I'd like a hot button in the second column that
would search for AP in column 1 in a table on another worksheet named Code
Table.
AP X
AR X
AS X
The table has 3 columns, (a, b c) and multiple rows. The code is in the
column A in each row, but may be repeated on multiple rows. Columns B and C
will be unique.
AP Data1b Data1c
AP Data2b Data2c
AR Data3b Data1c
The hot button beside code AP on the Code List worksheet should search the
Code Table and retun all the data relavent to AP regardless of how many rows
AP is found on.
Data1b Data1c
Data2b Data2c
VLOOKUP may not be powerful enough.
Worksheet 1, named Code List, has two columns. The first column contains a 2
digit code, AP for instance. I'd like a hot button in the second column that
would search for AP in column 1 in a table on another worksheet named Code
Table.
AP X
AR X
AS X
The table has 3 columns, (a, b c) and multiple rows. The code is in the
column A in each row, but may be repeated on multiple rows. Columns B and C
will be unique.
AP Data1b Data1c
AP Data2b Data2c
AR Data3b Data1c
The hot button beside code AP on the Code List worksheet should search the
Code Table and retun all the data relavent to AP regardless of how many rows
AP is found on.
Data1b Data1c
Data2b Data2c