Excel if statement

  submarine 19:29 19 Apr 2004
Locked

Here is one for an expert waiting to happen!
I have a two spreadsheets, Clients and Invoice

if just ONE of the cells in spreadsheet Clients!K4 to Clients!K85 = Yes then
cell in spreadsheet Invoice!M15 = corresponding value in Clients!A(whatever that row number is)

Can anyone please help?

  Forum Editor 19:32 19 Apr 2004

he'll be online soon enough.

  VoG II 20:29 19 Apr 2004

In Invoice!M15

=IF(COUNTIF(Clients!K4:K85,"Yes")=1,INDIRECT("Clients!A"&MATCH("Yes",Clients!K4:K85,0)+3),"")

  submarine 21:23 19 Apr 2004

Thanks very much for that........ you are brill!!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?