Corticus
Well-known Member
- Joined
- Apr 30, 2002
- Messages
- 1,579
Hi all,
This formula works, but is very ugly, and slowing down my sheet a bit. Just for the sake of academia, is there a better way? BTW, the formula is designed to do a simple vlookup, but allow for different formats(text/number) without returning errors:
=IF(ISERROR(VLOOKUP(TEXT(AE2,"#########"),Master,13,0))=TRUE,IF(ISERROR(VLOOKUP(AE2+0,Master,13,0))=TRUE,IF(ISERROR(VLOOKUP(AE2,Master,13,0))=TRUE,"",VLOOKUP(AE2,Master,13,0)),VLOOKUP(AE2+0,Master,13,0)),(VLOOKUP(TEXT(AE2,"#########"),Master,13,0)))
Thanks,
Corticus
This message was edited by Corticus on 2002-10-25 15:28
This formula works, but is very ugly, and slowing down my sheet a bit. Just for the sake of academia, is there a better way? BTW, the formula is designed to do a simple vlookup, but allow for different formats(text/number) without returning errors:
=IF(ISERROR(VLOOKUP(TEXT(AE2,"#########"),Master,13,0))=TRUE,IF(ISERROR(VLOOKUP(AE2+0,Master,13,0))=TRUE,IF(ISERROR(VLOOKUP(AE2,Master,13,0))=TRUE,"",VLOOKUP(AE2,Master,13,0)),VLOOKUP(AE2+0,Master,13,0)),(VLOOKUP(TEXT(AE2,"#########"),Master,13,0)))
Thanks,
Corticus
This message was edited by Corticus on 2002-10-25 15:28