What IF with a LOOKUP

[drewkenna]

Hi
Im not sure if its possible (im quite a novice)

I have 2 spreadsheets.
i need to complete a new colum on my main spreadsheet
The data in this new column (column C) will depend on if any cell from column A in sheet 1 matches any cell in column A in sheet 2.
If they match i want my new colimn to show the data in column B of sheet 2
If it does not match i want it to show the data in column B in sheet 1.

I really hope this makese sense.

 

[FDibbins]

Not sure if I understand you correctly, but maybe something like this?

=iferror(vlookup(A!,sheet2!$A$1:$B$100,2,0),B2