Merging spreadsheets with two common columns but include different heading columns

[camollibell]

Hello,
I hope someone out there may assist. I am trying to merge alot of data atm. I have one workbook with extensive data and column headings. I am attempting to merge data from other worksheets where the common denominators are two columns. So basically, I want the main document to accept a merge when the data in the rows for the two columns match.

I am not sure if this is enough information to put out there. I have attempted to google an answer but have not been successful in putting in a correct formula.

Thanking anyone in anticipation.

 

[ravishankar]

it is vague. perhaps VLOOKUP can help you.
ravi shankar