Macro - Insert text based on text in a list

[sedanstr]

Hi

I need help with a macro. I have two lists in A-B and E-F. I want the text in F to be inserted in C with the corresponding values in B and E.
macro.jpg

Thanks in advance.

[Bernie Deitrick]

Just use a formula. In C3, try either

=IFERROR(VLOOKUP(B3,E:F,2,False),"")

or

=IF(COUNTIF($B$3:B3,B3)=COUNTIF(B:B,B3),IFERROR(VLOOKUP(B3,E:F,2,FALSE),""),"")

(I'm not sure of what your actual logic is....)