The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.
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