D
D Gladieux
Table Lookup Limitations ? ? ?
My object is to automate a form report of pre worded
statements generated from a code that selects (YOU HAVE
statements) # 1-27 and (WE RECOMMEND statements) # 28-62
from -Table1- and displayed in cells to be merged to word
in a table named -Data-
I am using excel as the data merge source document and
every thing seems to work until statement # 30 then excel
repeats statement #31 over and over regardless of the
code number above #27 entered.
Excel sheet -Table1- column 1 is numbered consecutively 1
to 62 with column 2 containing the statements that I want
to select for the merge.
The first formula for the (YOU HAVE statements) 1-27 is:
=IF(AND(U2>0,U2<28),VLOOKUP(U2,Table1,2)””) this works
fine, no hitches at all.
The second formula that is giving me fits for the (WE
RECOMMEND statements) #28-62 is:
=IF(AND(A12>27,A12<63)VLOOKUP(A12,Table1,2)””) this works
until statement #30 and then statement #31 is repeted
over and over regardless of the line number requested.
This procedure is the selection procedure within excel
pages Data and Table1. the mail merge works but the
tables don’t talk together correctly.
My object is to automate a form report of pre worded
statements generated from a code that selects (YOU HAVE
statements) # 1-27 and (WE RECOMMEND statements) # 28-62
from -Table1- and displayed in cells to be merged to word
in a table named -Data-
I am using excel as the data merge source document and
every thing seems to work until statement # 30 then excel
repeats statement #31 over and over regardless of the
code number above #27 entered.
Excel sheet -Table1- column 1 is numbered consecutively 1
to 62 with column 2 containing the statements that I want
to select for the merge.
The first formula for the (YOU HAVE statements) 1-27 is:
=IF(AND(U2>0,U2<28),VLOOKUP(U2,Table1,2)””) this works
fine, no hitches at all.
The second formula that is giving me fits for the (WE
RECOMMEND statements) #28-62 is:
=IF(AND(A12>27,A12<63)VLOOKUP(A12,Table1,2)””) this works
until statement #30 and then statement #31 is repeted
over and over regardless of the line number requested.
This procedure is the selection procedure within excel
pages Data and Table1. the mail merge works but the
tables don’t talk together correctly.