If condition

Hi!

Appreciate and thanks for all your prior support!

I have a column "A" with Cities and States and the next column "B" with the assessment rates of the corresponding City or State. (without repetition)

Again i have a long list of Cities and states in Column " E " which has redundant entries.... which makes the list pretty long..

I require the Assessment rates of the Cities and States in column "B" to be filled to all the redundant entries ... to column "F" correspondingly.....

If the assessment rate or city or state is not present in columns "A & B" it should return an "NA"

Please check the Excel file for more clarification....


I appreciate your early reply


Note: If anymore clarifications please do not hesitate to reply!