=IF(C79="","",VLOOKUP(C79,$C$505:$CN$556,90,FALSE)) ---
--- this is the actual formula and i had to make some change in the sheet and as i added some columns;
it changed to =IF(C79="","",VLOOKUP(C79,$C$505:$CR$556,90,FALSE)) but only gives me a ( - ) as a result,
so i tried changing it to--- =IF(C79="","",VLOOKUP(C79,$C$505:$CR$556,96,FALSE))
however, for some reason it is giving me #ref! error
would be grateful if anyone could explain my mistake.
thank you
--- this is the actual formula and i had to make some change in the sheet and as i added some columns;
it changed to =IF(C79="","",VLOOKUP(C79,$C$505:$CR$556,90,FALSE)) but only gives me a ( - ) as a result,
so i tried changing it to--- =IF(C79="","",VLOOKUP(C79,$C$505:$CR$556,96,FALSE))
however, for some reason it is giving me #ref! error
would be grateful if anyone could explain my mistake.
thank you