IF(ISNA similar formula to avoid duplication lookup formulas.

[SystematicSyntax]

Hi forum,

Sorry if the title didn't really make comprehensible sense, but nevertheless, I'm returning once more to ask a question about the IF(ISNA formula and using it with VLOOKUP. Apologies if this has been asked, I did a quick search but I didn't know how to word it to get accurate results and a search on ISNA spat out a load of irrelevant threads glancing across titles.

Please Login or Register  to view this content.

Is the formula I currently use, but I am wanting to add in a ISNA check as if the value returned is lower than the lowest value in the respective table assigned to that specific formula it returns #N/A which throws the formulas off in the cells following after it. I am working on about 1500 lines (read:rows) of this so duplicating the VLOOKUP formula twice every line I think would be a little tedious and consuming for excel to workout.

Help is very much appreciated.

Thanks.

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[SystematicSyntax]

Seriously?....

God damnit. I have much to learn.

Thanks!

[TMS]

You're welcome.