Kiến thức

How to use IF, ISNA and VLOOKUP function in Excel?

sarah

December 20, 2019 at 5:03 pm

Is there a way to get a vlookup to replace an NA from another vlookup? I have 2 sheets, one is hr and one is our data, hr has the updated info and ours have some lines that the hr file does not. when searching for the changes, I do want to pull in information so it will be easier to copy and paste but I need all the info in a combined sheet that works automatically. I have it so it pulls in the HR data but I need all the nas to fill in with our data if they appear. Please tell me this is possible!

Reply

Chuyên mục: Kiến thức

Related Articles

Trả lời

Email của bạn sẽ không được hiển thị công khai. Các trường bắt buộc được đánh dấu *

Check Also
Close
Back to top button