Vllokup, then an if

[nobbsy]

Hi,

I am using an if statement in a spreadsheet (see below)
=IF('Microsoft Word'!C4="","",COUNTIF('Microsoft Word'!$C4:$N4,1)+COUNTIF('Microsoft Word'!$C4:$N4,2))

At the moment i am hoping the rows on the various spreadsheets are alighed together. I want to be able to put in a Vlookup, before it performs the if, so i am able to sort one of the spreadsheets at a later date.

The vlookup will need to check the first cell in the row is the same as the other spreadsheet, then when it is start the if statement.

Thanks
Sorry if the explanation s bad...

[/img]

 

[NBVC]

I think you have to explain better what you are trying to do.

It sounds like you need a nested if,

Something like: =If("first row in cell"='Microsoft Word'!"first row in cell", insert your original IF statement here,"") ?