Table If and Vlookup

[craig80]

Hello,

I have a table of data, which is updated daily. This is a full upload, not delta. Against each line i have formula for various status, which are then returned in Pivot tables. All works well for the Business i am in. But i need to enter a IF combined with a VLOOKUP. I have not had a problem in the past. However can't get past this one.

I use Named Ranges normally, but i had no luck at all with these, so i have replaced them with fixed ranges, as you can see below.

=IF([@[MU_NO]]<>Control!$G$2:$G$74,[@[Planner Group Desc '[D&R']]],VLOOKUP([@[MU_NO]],Control!$G$1:$J$74,2,FALSE))

The problem i am having with the above, it would appear that the formula is only work for as many row in the table as there are rows in the VLOOKUP table. (73) i have tried removing all names, even outside of my table. But still no luck.

If anyone has any advice, i would be very grateful.

Thanks

Craig

 

[Dryver14]

I am not sure what this part is

=IF([@[MU_NO]]<>Control!$G$2:$G$74

you seem to be comparing a singe item to a range..is that the case?

 

[craig80]

Hello,

Without the table and range references. It would look like this.

=IF(A4<>E2:E75, B4, Vlookup(A4, E2:H75,2,False))

It is correct, i am trying to find a single item in that range?

Thanks

Craig