ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I copy info while matching labels? (https://www.excelbanter.com/excel-worksheet-functions/128368-how-do-i-copy-info-while-matching-labels.html)

cmccurdy23

How do I copy info while matching labels?
 
I am trying to sort through old documents any copy data into a master
spreadsheet. I need to match row lables while doing this. I know how to use
lookup, but this will not work because the old data does not list all labels
and even lists incorrect labels.

For example, my labels a

AA
AB
AC
AD...so on

But the old data labels a

AA
AC (does not even have AB)
A2 (incorrect label)

Thank you for any help!


All times are GMT +1. The time now is 03:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com