As was foretold, we've added advertisements to the forums! If you have questions, or if you encounter any bugs, please visit this thread: https://forums.penny-arcade.com/discussion/240191/forum-advertisement-faq-and-reports-thread/
Options
Excel help (VLOOKUP) SOLVED
El Mucho
Registered User regular
Registered User regular
I'm having trouble getting a formula to work and I know there are a few Excel wizards on the forums so if someone can point me in the correct direction it would be much appreciated.
Here's the formula:
=IF(AND(ISNA(VLOOKUP($CI34, Sample_info, 2, FALSE)), VLOOKUP($CI34, !Sample_info, 2, FALSE)=" "), " ", VLOOKUP($CI34, !Sample_info, 2, FALSE))
The gist of the formula is that the VLOOKUP searches a table of Sample information and based on the LAB ID entered pulls the relevant information. However occasionally one of the columns will be empty. The VLOOKUP always returns a 0 in this instance and I would prefer if the cell was simply blank.
Any help would be much appreciated.
EDIT: I'm a dummy, I used OR instead of AND. This thread can be closed. Sorry :P
Here's the formula:
=IF(AND(ISNA(VLOOKUP($CI34, Sample_info, 2, FALSE)), VLOOKUP($CI34, !Sample_info, 2, FALSE)=" "), " ", VLOOKUP($CI34, !Sample_info, 2, FALSE))
The gist of the formula is that the VLOOKUP searches a table of Sample information and based on the LAB ID entered pulls the relevant information. However occasionally one of the columns will be empty. The VLOOKUP always returns a 0 in this instance and I would prefer if the cell was simply blank.
Any help would be much appreciated.
EDIT: I'm a dummy, I used OR instead of AND. This thread can be closed. Sorry :P
BNet: ElMucho#1392
Origin: theRealElMucho
Origin: theRealElMucho
El Mucho on
0