Comparing 2 Columns

[tstoneh]

Is there a way to compare two columns with the same information in different spreadsheets and then put a formula in the column if they agree -- not just a true of false?

 

[tstoneh]

such as =VLOOKUP("*+A2",Sheet1!$A$5:$D$49219,2,0)

 

[Ahnold]

=VLOOKUP("*"&A1,Sheet1!$A$5:$D$49219,3,0)

 

[tstoneh]

Hey that worked. That is great thank you very much. Can you tell what that actually does to the formula by putting those charaters in?

 

[Ahnold]

When you put characters in quotes they become text and the & sign is the same as the Concatenate Function (it combines text).

Glad I could help

 

[tstoneh]

Thanks again to all for their help.