Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-25-2017, 04:41 AM
haginho haginho is offline Need help with a formula Windows 7 64bit Need help with a formula Office 2013
Novice
Need help with a formula
 
Join Date: Apr 2017
Posts: 3
haginho is on a distinguished road
Default Need help with a formula

Hi everyone,

I am new here so please allow me to greet you, the kind future helper and current reader. I am trying to create a formula that would check values in column with country codes, compare it to a list of valid country codes and if it finds one, check another column with full country names and compare it to a list of valid country names. In essence what my task comes down to is that I have a very long list of records with user account details and need to validate if all of them have country code assigned and if it matches the country name to remove users with missing or incorrect data. My approach to this task would be to create a table of all country codes and country names and perhaps use vlookup or if function to browse through the user list. I will higly appreciate your help with this task.



Thank you very, very much (in advance, but will surely thank afterwards as well),

Jan
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
I need help with a formula Master_L Excel 2 12-01-2016 06:06 PM
Need help with a formula Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula innkeeper9 Excel 2 09-13-2016 08:59 PM
Need help with a formula formula rolyreefer Excel 1 03-14-2016 08:36 AM
Need help with dragging a formula and changing a reference column as I drag the formula. LupeB Excel 1 10-22-2015 03:02 PM
Need help with a formula Need Help w/Formula OSCAR MARTINEZ Excel 1 09-28-2013 05:39 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:31 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft