Need a formula to return a value by looking a table from another sheet.
I have Source sheet with a list of names. In Target sheet, I will be having a column with other set of names. Need to compare the names in Target sheet with Source sheet and return the value which has same name. However, if the name list in the Target sheet does not match the name list in the Source sheet then "NA" value needs to be returned.
Example: Source Sheet:
Help Article Resources
Check out the Formula Handbook template!