Vlookup with condition

[nagesh.tvsr]

Hi,

Need a formula to lookup with condition.

An excel file attached with details.

Pl. help.

Thanks,
Nagesh.

[ORoos]

If the list is always in order of the Job-No, then that should do: =IF(F3<>F2,VLOOKUP($F3,$B$3:$C$6,2,0),0)
If the Job-No are mixed, then another approach with countif may work.

[ORoos]

If the Job-No are not sequential, try: =IF(COUNTIF($F$3:F3,F3)=1,VLOOKUP($F3,$B$3:$C$6,2,0),0) in J3 and pull down.

[nagesh.tvsr]

Thank you ORoos.

Since my Job No. column is not sorted, your 2nd formula is working fine.

Thanks a Ton.

Nagesh.

[ORoos]

You are welcome Nagesh.
Thanks for the rep.