开发者

Matching difficulty from 2 different worksheets of repetitive values

开发者 https://www.devze.com 2023-02-10 14:49 出处:网络
I have the following case: Worksheet2: I have 3 columns in Worksheet2 Sales Account Name Sales Rep No. Sales Level 6 Name

I have the following case:

Worksheet2: I have 3 columns in Worksheet2

  1. Sales Account Name
  2. Sales Rep No.
  3. Sales Level 6 Name

Worksheet1:

I have 3 columns in worsheet1

  1. ERP/Segment1
  2. Misc6
  3. Misc7

My aim here is to read each line from worksheet1 and look for matching values from ERP/Segment1 开发者_JAVA技巧matching Sales Account Name from worsheet2 and insert the Sales Level 6 Name in Misc6. Can someone help please.


You might like to read Excel VBA to match and line up rows


Why can't you use a VLookup - Do you need to insert multiple Sales Account names into the Misc6 column?

Can you post an example of your data?

0

精彩评论

暂无评论...
验证码 换一张
取 消