Hi there,
Having a brain freeze and cant get this to work and not sure where wrong although it does look untidy..
=IF($h12=$A$12,(ISNA(VLOOKUP($I12,nhs,2,0),"",VLOOKUP($I12,nhs,2,0)),=IF($H12=$A$13,(ISNA(VLOOKUP($I12,nhsb,2,0),"",VLOOKUP($I12,nhsb,2,0)),(ISNA(VLOOKUP($I12,nhsc,2,0)),"",VLOOKUP($I12,nhsc,2,0)))
I have a Month Value in Cells A12, A13 and A14
I have a drop down in column H that the user chooses a month then in column I enters an employee number.
I have 3 different worksheets ..one has a named range within that for nhs , the other nhsb and the other named range is nhsc
so what I am trying to achive is to enter the value of month in cell H12 then employee number in cell I12 then if H12 = A12 then cell I12 should lookup named range nhs,2,0....if H12 =A13 then I12 should lookup named range nhsb,2,0..otherwise value in I12 should look up named range nhsc,2,0
hope that makes sense and also need the isna as dont want NA appearing
hoping someone can make sense of this and help..
Having a brain freeze and cant get this to work and not sure where wrong although it does look untidy..
=IF($h12=$A$12,(ISNA(VLOOKUP($I12,nhs,2,0),"",VLOOKUP($I12,nhs,2,0)),=IF($H12=$A$13,(ISNA(VLOOKUP($I12,nhsb,2,0),"",VLOOKUP($I12,nhsb,2,0)),(ISNA(VLOOKUP($I12,nhsc,2,0)),"",VLOOKUP($I12,nhsc,2,0)))
I have a Month Value in Cells A12, A13 and A14
I have a drop down in column H that the user chooses a month then in column I enters an employee number.
I have 3 different worksheets ..one has a named range within that for nhs , the other nhsb and the other named range is nhsc
so what I am trying to achive is to enter the value of month in cell H12 then employee number in cell I12 then if H12 = A12 then cell I12 should lookup named range nhs,2,0....if H12 =A13 then I12 should lookup named range nhsb,2,0..otherwise value in I12 should look up named range nhsc,2,0
hope that makes sense and also need the isna as dont want NA appearing
hoping someone can make sense of this and help..