I have a two workbooks of data. The First workbook contains all the products that my company is trying to produce while the other workbook has data from a plant we use that shows what they say we have told them to produce. I've been comparing both spreadsheets in order to see if this plant has the same data as we do at the main office.

So far I have 3 Vlookups that ask:

1) Is the specific job on the Plant workbook on the main workbook?

2) Is the specific job on the Plant workbook on the main workbook, but within the Option A sheet?

3) Is the specific job on the Plant workbook on the main workbook, but within the discontinued sheet?

I have each Vlookup returning a simple "yes" or "no". I wish to find a way to populate another column that will list the reason why the job is discontinued, if of course it is on the discontinued sheet.

So I would only look on the "Is it Discontinued" column for instances of the word "yes". On the Discontinued sheet, there is a column that says a few words on why the job was discontinued. I would like to find a way of creating an IF statement that would basically say:

IF - Discontinued Vlookup column says yes - populate cell with the '[MainWorkbook]DiscontinuedSheet'DiscontinuedReason for that specific job #.

I know this could be done by an IF statement, but I'm not sure how to accomplish this. The Vlookup I've created to give a better perspective on how the spreadsheets are setup is like this:

=IF(ISNA(VLOOKUP(A2,'[MainWorkbook.xls]Discontinued'!$1:$10000,1,FALSE)),"No","Yes")

I know the IF statement would get this done, just not sure how to handle the True statement.

Any help would be awesome!!