I am trying to copy tables with data from a Word document into an excel
database. Both the Word table and the Excel database have labels (in excel
they are located down column A). I want the corresponding data to copy from
the word document into the Excel spreadsheet. The problem is that someone
else created the labels in the Word Table, so not all labels are present and
some labels are incorrect (so they are not in my Excel spreadsheet). This
makes it impossible for me to use LOOKUP. Is there any other way to make
sure that corresponding data gets put into the correct field?

Here's a short sample of both:

(This is the first 3 entries in the Word table)
AAH 2
ABE 9
ABI 2
ABQ 11

(These are my first 4 labels in Excel)
ABE
ABI
ABQ
ABR

hi

Try VLOOKUP, and use FALSE as the final condition in the function

Woody

"cmccurdy23" wrote:

I am trying to copy tables with data from a Word document into an excel
database. Both the Word table and the Excel database have labels (in excel
they are located down column A). I want the corresponding data to copy from
the word document into the Excel spreadsheet. The problem is that someone
else created the labels in the Word Table, so not all labels are present and
some labels are incorrect (so they are not in my Excel spreadsheet). This
makes it impossible for me to use LOOKUP. Is there any other way to make
sure that corresponding data gets put into the correct field?

Here's a short sample of both:

(This is the first 3 entries in the Word table)
AAH 2
ABE 9
ABI 2
ABQ 11

(These are my first 4 labels in Excel)
ABE
ABI
ABQ
ABR

Could you please give me a sample of the formula? I have little experience
with vlookup and false. I found this solution in the help menu, but could
not figure out how to use it.

Thanks!

"Woodsey" wrote:

hi

Try VLOOKUP, and use FALSE as the final condition in the function

Woody

"cmccurdy23" wrote:

I am trying to copy tables with data from a Word document into an excel
database. Both the Word table and the Excel database have labels (in excel
they are located down column A). I want the corresponding data to copy from
the word document into the Excel spreadsheet. The problem is that someone
else created the labels in the Word Table, so not all labels are present and
some labels are incorrect (so they are not in my Excel spreadsheet). This
makes it impossible for me to use LOOKUP. Is there any other way to make
sure that corresponding data gets put into the correct field?

Here's a short sample of both:

(This is the first 3 entries in the Word table)
AAH 2
ABE 9
ABI 2
ABQ 11

(These are my first 4 labels in Excel)
ABE
ABI
ABQ
ABR