Hi,
I was wondering if anyone can help me with my IF function.
IF(G4="B",VLOOKUP(G4,NEWSHIFTS,3),0))+IF(H4="B",VLOOKUP(H4,NEWSHIFTS,3),0)
The above formula continues for quite a few repeats.
I want it to find any cell with a B* and then look at the newshifts vlookup and add the numbers together.
However I can only get it to work when I change the "B" to "B1" or "B2" etc for the corresponding cell because the *, ? and ~ wildcards don't work.
Please help
Thanks Emma
I was wondering if anyone can help me with my IF function.
IF(G4="B",VLOOKUP(G4,NEWSHIFTS,3),0))+IF(H4="B",VLOOKUP(H4,NEWSHIFTS,3),0)
The above formula continues for quite a few repeats.
I want it to find any cell with a B* and then look at the newshifts vlookup and add the numbers together.
However I can only get it to work when I change the "B" to "B1" or "B2" etc for the corresponding cell because the *, ? and ~ wildcards don't work.
Please help
Thanks Emma